Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group