Re: Shutdown pg db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
Cc: "Ganesan Kanavathy" <ganesh(at)magnusquest(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Shutdown pg db
Date: 2003-12-15 16:10:01
Message-ID: 12970.1071504601@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Uwe C. Schroeder" <uwe(at)oss4u(dot)com> writes:
> NEVER kill -9 a postmaster
> Althoug funny enough it pretty often tolerates that kind of killing, it will
> not allow the process to properly shut down the database. So you may or may
> not be lucky to end up with a good database.

The database is safe enough. What you are likely to have trouble with
is starting a fresh postmaster --- kill -9 prevents the postmaster from
releasing shared memory, for example, and you may not have a high enough
SHMMAX to just go and create another shared memory segment. Do it a few
times in a row and you'll almost surely overrun SHMMAX. This will leave
you having to manually remove the old shared memory, or reboot the
machine, before you can restart Postgres.

Use the documented methods for shutting down Postgres.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-12-15 16:18:55 Re: Moving a database AND changing the superuser
Previous Message Marek Florianczyk 2003-12-15 15:56:24 Re: Moving a database AND changing the superuser