Re: could you tell me this..? - Mailing list pgsql-general

From Vick Khera
Subject Re: could you tell me this..?
Date
Msg-id AANLkTinfe3s=aqZBXBKp2SvhdF7rNPWR9yEfyRdPKbA1@mail.gmail.com
Whole thread Raw
In response to Re: could you tell me this..?  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
On Thu, Aug 5, 2010 at 9:40 AM, Szymon Guz <mabewlun@gmail.com> wrote:
> killing it with -9 crashed the whole PostgreSQL server, don't do that.
> Instead just login to the database and run the function
> pg_cancel_backend() http://www.postgresql.org/docs/8.4/static/functions-admin.html,
> much more safe way.

Or, assuming you're still in the shell typing those commands, just hit
ctrl-c to cancel the current query.

pgsql-general by date:

Previous
From: "Richard"
Date:
Subject: Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?
Next
From: Marco Colombo
Date:
Subject: Re: solaris slow