BUG #6140: PostgreSQL Server Service Not Starting - Mailing list pgsql-bugs

From Steve Boyd
Subject BUG #6140: PostgreSQL Server Service Not Starting
Date
Msg-id 201108021201.p72C1nDx013168@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6140: PostgreSQL Server Service Not Starting
List pgsql-bugs
The following bug has been logged online:

Bug reference:      6140
Logged by:          Steve Boyd
Email address:      sboyd67@yahoo.com
PostgreSQL version: 8.3.12
Operating system:   Windows Server 2003 R2 SP2
Description:        PostgreSQL Server Service Not Starting
Details:

Good morning!

I've searched through the bug archives but can't seem to find an answer to
this issue.  We have version 8.3.12 installed and the PostgreSQL server
service is trying to start but doesn't. I receive the following message when
I click on the service:

"The PostgreSQL Server 8.3 service on Local Computer started then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alerts service."

I've checked the PostgreSQL logs and there is nothing there.  The last log
entry was in May.  I've checked the windows event viewer and get the
following error message:

"could not open process token:  error code 5"

The service account is in the local administrators group and has full
control over the data directory.  Not sure what has changed.  I even
re-entered the password to confirm that the "logon as a service right" was
granted.

 I was going to try to upgrade to 8.3.15 but since pgdumpall won't work if
the service is not running, that's not an option.

Not sure where else to look.  Any help is appreciated.

Best regards,

Steve

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6139: LIMIT doesn't return correct result when the value is huge
Next
From: Jon Nelson
Date:
Subject: Re: backend for database 'A' crashes/is killed -> corrupt index in database 'B'