From: Sofer, Yuval [mailto:Yuval_Sofer@xxxxxxx] Sent: Thursday, August 11, 2011 6:01 AM To: pgsql-admin@xxxxxxxxxxxxxx Cc: Zucker, Yehudit Subject: Postgres service starts and then stops immediatly Hi, -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 stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service." -No logs in the postgres log file -When using pg_ctl, the postgres.exe is starting OK Please help, Thanks, Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuval_sofer@xxxxxxx Yuval, Using pg_ctl, did you try to start PG as a service? e.g.: C:/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "PostgreSQL" -D "C:/PostgreSQL/8.4/data" -w 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. Regards, Igor Neyman -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
