Обсуждение: PID file

Поиск
Список
Период
Сортировка

PID file

От
Ing. Jorge S Alanís Garza
Дата:

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

От
Andrew Sullivan
Дата:
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/