Re: restarting after power outage

From: Peter Wiersig <peter(at)friesenpeter(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: restarting after power outage
Date: 2005-04-27 19:45:56
Message-ID: 20050427194556.GC4032@london087.server4you.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 27, 2005 at 03:03:50PM -0400, Doug McNaught wrote:
>
> What I have done is to create a separate init.d script that
> removes the PID file, and arrange for it to run before the PG
> startup script.

An even better place (if you really want to do all this) would be
something that happens only at boot time.

On a Debian system a skript linked to /etc/rcS.d/ would be in
order, on SUSE I would rm it in /etc/init.d/boot.local.

But I advise against it. Do things like that manually after you've
checked that your pgsql-partition is mounted and filled with
correct data.

Some of the distributed init.d skripts for starting postgres also
initdb the data-location if they think they should. That can lead
to the total loss of your cluster.

--
Peter

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2005-04-27 19:54:50 Re: restarting after power outage
Previous Message Michael Fuhr 2005-04-27 19:45:34 Re: populating a table via the COPY command using C code.