Обсуждение: Having Issue Getting the Postgresql Service to Start

We are running Postgresql 9.0 64-bit on a Windows Server 2003 machine. Whenever we try to start the postgresql-x64-9.0 service, we eventually get the error “The postgresql-x64-9.0 service on Local Computer started and stopped.” The user account trying to start the service has administrator rights on both the server and the Postrgesql folders. Does anyone have any clues as to why this is happening? Thanks!

The application log has this entry:

The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Waiting for server startup...

The System Log has these entries:

The postgresql-x64-9.0 service was successfully sent a start control.

The postgresql-x64-9.0 service entered the stopped state.

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.

Removing the administrator rights worked and the service is now able to start over the domain. Thanks for the help!

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

Removing the administrator rights worked and the service is now able to start over the domain. Thanks for the help!