> -----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
> I'm on Windows XP with postgresql 8.4 installed by
> 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").
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.
In response to
pgsql-general by date
|Next:||From: Dennis C||Date: 2010-06-28 20:01:05|
|Subject: Re: PG dump and restore|
|Previous:||From: GEORGE KEVIN||Date: 2010-06-28 19:01:45|
|Subject: Vamos fazer esta operação|