Thread: PID file

PID file

From

Ing. Jorge S Alanís Garza

Date:

29 September 2008, 17:52:53

Hello,

We are operating Postgresql 8.2 on an ISCSI environment. Sometimes there are issues with the ISCSI so Postgresql refuses to shutdown properly, or start, because of the pid file. My question is, what is the correct thing to do with this pid file? On some test-environments I have deleted the pid and then when starting up, I see postgres complain about the database not shutting down cleanly. Is there a way to recover the non-working postgres instance? Is this a very corruption-prone environment?

Thanks,

Jorge Santiago Alanís Garza
Innovación y Desarrollo
jorge.alanis@blocknetworks.com.mx

Tel: (81) 4444.4044
Cel: (811) 243-6570

www.blocknetworks.com.mx
Av. Lázaro Cárdenas 4000, L-17
Col. Valle de las Brisas
Monterrey, Nuevo León, CP 64790
Tel: +52 (81) 4444 4044

Re: PID file

From

Andrew Sullivan

Date:

29 September 2008, 18:59:35

On Mon, Sep 29, 2008 at 12:43:54PM -0500, Ing. Jorge S Alanís Garza wrote:
> shutting down cleanly. Is there a way to recover the non-working postgres
> instance? Is this a very corruption-prone environment?

It's sure corruption-prone if you delete the pidfile.

If your iSCSI system keeps dropping out on you, then you need to fix
that.  Otherwise, things are going to break in a way you'll be unhappy
with later.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/