R: Re: postgres user password: Log on failure
Hi guys,
Thanks for taking time to reply.
- Despite what the error message says, the user postgres doesn't have
administrator privileges (and I don't see why these would change by retyping
the password).
- In Control Panel -> Administrative Tools -> Computer Manager -> Users ->
postgres I see that postgres is member of the 'Users' group and its password
never expires.
Maybe I'm missing something obvious here...
Dario
Show quoted text
----Messaggio originale----
Da: vibhor.kumar@enterprisedb.com
Data: 29/06/2010 2.40
A: "Igor Neyman"<ineyman@perceptron.com>
Cc: <dario.ber@libero.it>, <pgsql-general@postgresql.org>
Ogg: Re: [GENERAL] postgres user password: Log on failureOn 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 CompanyOffice: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
-----Original Message-----
From: dario.ber@libero.it [mailto:dario.ber@libero.it]
Sent: Tuesday, June 29, 2010 3:38 AM
To: vibhor.kumar@enterprisedb.com; Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: R: Re: [GENERAL] postgres user password: Log on failureHi guys,
Thanks for taking time to reply.
- Despite what the error message says, the user postgres
doesn't have administrator privileges (and I don't see why
these would change by retyping the password).
- In Control Panel -> Administrative Tools -> Computer
Manager -> Users -> postgres I see that postgres is member of
the 'Users' group and its password never expires.Maybe I'm missing something obvious here...
Dario
That's why I told you to check if your WinOS password policy requires
regular change of account passwords.
Igor Neyman
On Tue, 2010-06-29 at 09:37 +0200, dario.ber@libero.it wrote:
Hi guys,
Thanks for taking time to reply.
- Despite what the error message says, the user postgres doesn't have
administrator privileges (and I don't see why these would change by retyping
the password).
- In Control Panel -> Administrative Tools -> Computer Manager -> Users ->
postgres I see that postgres is member of the 'Users' group and its password
never expires.Maybe I'm missing something obvious here...
Have you checked if the 'postgres' user is allowed to "login as a
service" in local/group policy?
The error about admin privileges may be masking the fact the postgres
user is trying to start a service, without the policy rights.
Cheers,
Dagan McGregor