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!
On Dec 12, 2011, at 9:00 PM, Sogard, Michael (DPS) wrote:
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!
Anything in the windows event logs? How did you register the service?
--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.
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.
From: Sachin Srivastava [mailto:sachin.srivastava@enterprisedb.com]
Sent: Monday, December 12, 2011 9:52 AM
To: Sogard, Michael (DPS)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Having Issue Getting the Postgresql Service to Start
On Dec 12, 2011, at 9:00 PM, Sogard, Michael (DPS) wrote:
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!
Anything in the windows event logs? How did you register the service?
--
Regards,
Sachin Srivastava
EnterpriseDB<http://www.enterprisedb.com>, the Enterprise PostgreSQL<http://www.enterprisedb.com> company.
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!
From: Craig Ringer [mailto:ringerc@ringerc.id.au]
Sent: Monday, December 12, 2011 5:48 PM
To: Sogard, Michael (DPS)
Cc: Sachin Srivastava; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Having Issue Getting the Postgresql Service to Start
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
On 14/12/2011 12:10 AM, Sogard, Michael (DPS) wrote:
Removing the administrator rights worked and the service is now able
to start over the domain. Thanks for the help!
Glad to hear it.
I'm inclined to think Pg needs a better error message in the logs and/or
to emit a service log warning when this condition is detected, since
I've seen several people confused by it over time.
--
Craig Ringer