postgres user password: Log on failure

-----Original Message-----
From: dario.ber@libero.it [mailto:dario.ber@libero.it]
Sent: Monday, June 28, 2010 11:41 AM
To: pgsql-general@postgresql.org
Subject: postgres user password: Log on failure

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

Does this XP has a policy set up, that requires every login to change
it's password every so often (say 30 days, or whatever)?
If so, exclude postgres account from this policy.

Regards,
Igor Neyman

On 28/06/10 8:58 PM, Igor Neyman wrote:

Log on failure: Only an unprivileged user can start

the server"; Error 1063; Error 1069).

Error Message shows that services are getting started with Admin Privileges.

Please use unprivileged user(i.e Non admin user) for starting the services.

--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb