What happens when you kill the postmaster?

From: Ralf Schuchardt <rasc(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: What happens when you kill the postmaster?
Date: 2010-01-13 10:25:53
Message-ID: 9940E5D1-C32D-4D36-9BBC-ADCCCD84A529@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

on one of our Mac servers an update (Remote Desktop Client) killed yesterday the postmaster process. Apparently this did not have any influence on existing connections and therefore was not detected until some time later, when no connection for a backup could be made.

I have then closed all apps with connections to the database. This brought the whole cluster down. It restarted then with some transaction log rollback messages and seems to be running fine since then.

Can I now expect that the database is in a consistent state, or must I assume the database is corrupted?
I could run a dump-all without problems and there are rows created after the death the postmaster.

Thanks.

Ralf Schuchardt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-01-13 11:01:40 Re: Extremely Slow Cascade Delete Operation
Previous Message Maximilian Tyrtania 2010-01-13 10:21:24 Re: Collate order on Mac OS X, text with diacritics in UTF-8