From: Sofer, Yuval
Sent: Thursday, August 11, 2011 6:01 AM
Cc: Zucker, Yehudit
Subject: Postgres service starts and then stops immediatly
-We are using Postgres 8.3.7 on Windows
-We cannot start the Postgres service. The windows OS error message is:
"The PostgreSQL Server 8.3 service on Local Computer started then
Some services stop automatically if they have no work to do, for
the Performance Logs and Alerts service."
-No logs in the postgres log file
-When using pg_ctl, the postgres.exe is starting OK
CTM&D Business Unit
Using pg_ctl, did you try to start PG as a service?
C:/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "PostgreSQL" -D
Could it be that account used to start PG service doesn't have
privileges to "run as a service"?
Check in "Local Security Settings" under "Local Policies"/"User Rights
Assignments" - make sure that "Log on as a service" granted to the
account specified in PG service properties.