Re: Having Issue Getting the Postgresql Service to Start

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: "Sogard, Michael (DPS)" <Michael(dot)Sogard(at)state(dot)mn(dot)us>
Cc: Sachin Srivastava <sachin(dot)srivastava(at)enterprisedb(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Having Issue Getting the Postgresql Service to Start
Date: 2011-12-12 23:47:46
Message-ID: 4EE692A2.7040305@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13/12/2011 12:18 AM, Sogard, Michael (DPS) wrote:
> A little more information that may help, the service works fine as a
> local user. The problem only happens when we try to start it as a
> network user on the domain. As far as registering the service goes, I
> am not sure of the details of the installation. That was performed
> from a different team than mine. They are also stumped as to why this
> is happening.

I've seen reports that PostgreSQL doesn't run properly when run as a
domain member user before, too. However, in this case the problem is
simpler:

The PostgreSQL account must **NOT** have administrator rights. Grant the
account full control over its data directory and REMOVE its
administrator rights.

--
Craig Ringer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-12-13 00:01:18 Re: Consecutive operators not recognized without whitespace
Previous Message Chris Angelico 2011-12-12 23:38:10 Consecutive operators not recognized without whitespace