Re: (Never?) Kill Postmaster?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christian Schröder <cs(at)deriva(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: (Never?) Kill Postmaster?
Date: 2007-11-09 00:17:08
Message-ID: 25055.1194567428@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?Christian_Schr=F6der?= <cs(at)deriva(dot)de> writes:
> I don't want to "kill -9" the processes because the last time
> I did this the database was in recovery mode for a substantial amount of
> time.

A useful tip on that: if you perform a manual CHECKPOINT just before
issuing the kills, recovery time should be minimal.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message smiley2211 2007-11-09 01:45:51 Re: pg_ctl & show all
Previous Message smiley2211 2007-11-09 00:14:37 pg_ctl & show all