Thread: What happens when you kill the postmaster?
Hi, on one of our Mac servers an update (Remote Desktop Client) killed yesterday the postmaster process. Apparently this didnot have any influence on existing connections and therefore was not detected until some time later, when no connectionfor 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 withsome 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
2010/1/13 Ralf Schuchardt <rasc@gmx.de>
It depends on the signal which was sent to the postgres process.
AFAIK, only SIGKILL (unconditional kill) can make some damage to the database.
see http://www.postgresql.org/docs/8.4/static/app-postgres.html forfull explanation
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.
It depends on the signal which was sent to the postgres process.
AFAIK, only SIGKILL (unconditional kill) can make some damage to the database.
see http://www.postgresql.org/docs/8.4/static/app-postgres.html forfull explanation
Thanks.
Ralf Schuchardt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/