Skip site navigation (1) Skip section navigation (2)

Re: Postgres service starts and then stops immediatly

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Cc: "Zucker, Yehudit" <Yehudit_Zucker(at)bmc(dot)com>
Subject: Re: Postgres service starts and then stops immediatly
Date: 2011-08-11 14:06:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

From: Sofer, Yuval [mailto:Yuval_Sofer(at)bmc(dot)com] 
Sent: Thursday, August 11, 2011 6:01 AM
To: pgsql-admin(at)postgresql(dot)org
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

Please help, 

Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team


Using pg_ctl, did you try to start PG as a service? 

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.

Igor Neyman

In response to

pgsql-admin by date

Next:From: CS DBADate: 2011-08-11 14:39:39
Subject: Master to Master replication options?
Previous:From: Nicholson, Brad (Toronto, ON, CA)Date: 2011-08-11 12:50:08
Subject: Re: initdb fails on AIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group