Re: postmaster.pid

From: Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster.pid
Date: 2003-01-03 10:45:33
Message-ID: 20030103103054.A3DCA4980D4@sea-gw.sea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Friday 03 January 2003 12:54, you wrote:
> Happy New Year to everyone (and especially to the PostgreSQL Developers)
> --------------------------
>
> My computer shut down unexpectedly because of a short-circuit in
> another room. The next time i powered on the computer, PostgreSQL
> did not start automatically: the old postmaster.pid was still there.
> So, I had to remove that file manually.
> ( everything was ok: the database did not suffer from this shock ).
>
>
> Tip Suggestion:
> i think that somewhere in the docs the administators
> should be advised to delete postmaster.pid automatically at boot
> time ( for example at the same time when the files in /tmp are
> deleted ).
> This way, in case of an unexpected shutdown, postgresql would be
> able to restart without any manual intervention.

Well, this is a *BAD IDEA*. Suppose, for example, your data is corrupt in
some special way, an due to your removal of the pid file, postmaster tries to
recover the database automatically and probably destroys all or data part of
the data. You would like to have been able to do a filseystem level backup
first...

Greetings,
Joerg
--
Leading SW developer - S.E.A GmbH
Mail: joerg(dot)hessdoerfer(at)sea-gmbh(dot)com
WWW: http://www.sea-gmbh.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message am 2003-01-03 11:54:44 postmaster.pid
Previous Message Patric Bechtel 2003-01-03 09:35:16 Re: [GENERAL] 7.3 Prepared statements [Viruschecked]