Skip site navigation (1) Skip section navigation (2)

Re: postgres user password: Log on failure

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: <dario(dot)ber(at)libero(dot)it>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres user password: Log on failure
Date: 2010-06-28 19:58:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

> -----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.

Igor Neyman

In response to


pgsql-general by date

Next:From: Dennis CDate: 2010-06-28 20:01:05
Subject: Re: PG dump and restore
Previous:From: GEORGE KEVINDate: 2010-06-28 19:01:45
Subject: Vamos fazer esta operação

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group