Re: postgres user password: Log on failure

> -----Original Message-----
> From: dario(dot)ber(at)libero(dot)it [mailto:dario(dot)ber(at)libero(dot)it]
> Sent: Monday, June 28, 2010 11:41 AM
> To: pgsql-general(at)postgresql(dot)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