Thread: 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
> -----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