pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPID file
2+ messages / 2 participants
[nested] [flat]
* PID file
@ 2008-09-29 17:43 Ing. Jorge S Alanís Garza <jorge.alanis@blocknetworks.com.mx>
0 siblings, 1 reply; 2+ messages in thread
From: Ing. Jorge S Alanís Garza @ 2008-09-29 17:43 UTC (permalink / raw)
To: pgsql-admin
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
<mailto:jorge.alanis@blocknetworks.com.mx>
jorge.alanis@blocknetworks.com.mx
Tel: (81) 4444.4044
Cel: (811) 243-6570
<http://www.blocknetworks.com.mx/; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PID file
@ 2008-09-29 18:59 Andrew Sullivan <ajs@commandprompt.com>
parent: Ing. Jorge S Alanís Garza <jorge.alanis@blocknetworks.com.mx>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Sullivan @ 2008-09-29 18:59 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-09-29 18:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-29 17:43 PID file Ing. Jorge S Alanís Garza <jorge.alanis@blocknetworks.com.mx>
2008-09-29 18:59 ` Andrew Sullivan <ajs@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox