Re: Database corrupted - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database corrupted
Date
Msg-id 4079.1323118432@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database corrupted  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Database corrupted  (Yann ROBIN <me.show@gmail.com>)
Re: Database corrupted  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Dec 5, 2011 at 1:18 PM, Yann ROBIN <me.show@gmail.com> wrote:
>> kill -9 of the writer process

> Are you sure you killed all the postgres backends before restarting
> the server?  If other backends are still running, with a dead
> postmaster, and you restart the server, instant corruption.

There are interlocks against that ... although if you were foolish
enough to manually remove postmaster.pid, you could defeat them :-(

            regards, tom lane

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Database corrupted
Next
From: Yann ROBIN
Date:
Subject: Re: Database corrupted