postgres user password: Log on failure

From: "dario(dot)ber(at)libero(dot)it" <dario(dot)ber(at)libero(dot)it>
To: <pgsql-general(at)postgresql(dot)org>
Subject: postgres user password: Log on failure
Date: 2010-06-28 15:41:00
Message-ID: 24624686.242471277739660782.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm on Windows XP with postgresql 8.4 installed by postgresql-8.4.4-1-windows.
exe with essentially default settings (only the path to the data dir was
changed from default).

I realized that sometimes (not always!) the server cannot start when I reboot
my machine (I get error messages on the line of "Log on failure: Only an
unprivileged user can start the server"; Error 1063; Error 1069).

It appears that the postgres user sometimes tries to log on with a wrong
password (or no password?) so that I have to go to
Control Panel -> Administrative Tools -> Services -> PostgreSQL -> Properties
and retype the correct password.

I would like to ask...
- Why does this happen? (I have installed postgresql a few times on different
machines and this is the first time I see this behavior)
- Why is the postgres password wrong/missing sometimes but not every time I
reboot?

Many thanks for any explanation
(Hopefully others will benefit from it... I spent quite some time to find out
out to fix this "log on failure").

Dario

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-06-28 15:44:02 Re: convert accented character to base character
Previous Message John R Pierce 2010-06-28 15:40:29 Re: convert accented character to base character