Thread: R: Re: postgres user password: Log on failure

R: Re: postgres user password: Log on failure

From
"dario.ber@libero.it"
Date:
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


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



Re: postgres user password: Log on failure

From
"Igor Neyman"
Date:

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


That's why I told you to check if your WinOS password policy requires
regular change of account passwords.

Igor Neyman

Re: R: Re: postgres user password: Log on failure

From
Dagan McGregor
Date:
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