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

From: Dagan McGregor <ardrigh(at)acsonline(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: R: Re: postgres user password: Log on failure
Date: 2010-06-30 05:17:34
Message-ID: 1277875054.2537.2.camel@tighanardrigh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2010-06-29 at 09:37 +0200, dario(dot)ber(at)libero(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2010-06-30 05:33:24 Re: alter table schema, default sequences stay the same
Previous Message Vick Khera 2010-06-30 01:39:17 Re: Postgresql partitioning - single hot table or distributed