Re: Error stopping postgresql service

Maalini -

On first glance (and not knowing the architecture of your particular 'service'), this looks very explainable on the basis of PostgreSQL being instructed to do a 'graceful' shutdown - while you may have users connected.

Depending on how your service 'stop' issues the shutdown command, PostgreSQL may never stop!

Probably need to give us more specifics about the layout of your service.

Lou Picciano

----- Original Message -----
From: "Maalini Samuganardan" <maalini(dot)sam(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Sent: Wednesday, February 23, 2011 9:20:10 PM
Subject: [ADMIN] Error stopping postgresql service

Hi,

I am getting an error when try to stop the postgresql server.
No problem starting.

Please find error message below.

Thank you.

[root(at)edbws01 run]# service postgresql status
postmaster is stopped
[root(at)edbws01 run]# service postgresql start
Starting postgresql service: [ OK ]
[root(at)edbws01 run]# service postgresql stop
Stopping postgresql service: [FAILED]
[root(at)edbws01 run]#

Regards,
Maalini