Re: R: Re: postgres user password: Log on failure - Mailing list pgsql-general

From Dagan McGregor
Subject Re: R: Re: postgres user password: Log on failure
Date
Msg-id 1277875054.2537.2.camel@tighanardrigh
Whole thread Raw
In response to R: Re: postgres user password: Log on failure  ("dario.ber@libero.it" <dario.ber@libero.it>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: alter table schema, default sequences stay the same
Next
From: Adrian von Bidder
Date:
Subject: Re: Migrating from MySQL