Re: how can we resolving locking state .... - Mailing list pgsql-general

From Scott Marlowe
Subject Re: how can we resolving locking state ....
Date
Msg-id AANLkTimDcPP2RmbeVQvHN0MaGccOXzPgbrGRZcbFkBTO@mail.gmail.com
Whole thread Raw
In response to how can we resolving locking state....  (노현석<noh019@naver.com>)
List pgsql-general
Please post in plain text if possible.

2010/8/5 노현석 <noh019@naver.com>
>
> hi..
>
> we test   locking      PostgreSQL 8.4.4 on x86_64.
> $
> $   kill -9   5143

What you want is plain old

kill 5143
or
kill -SIGTERM 5143

Kill -SIGTERM is like using a fly swatter to kill a fly.  SIGKILL (-9)
is like lobbing a grenade in the same room to kill said fly.

Note that in 8.4 and up there's a pg function to do this.  8.3 and
before kill -SIGTERM is what you want.

pgsql-general by date:

Previous
From: Andreas 'ads' Scherbaum
Date:
Subject: Re: how can we resolving locking state....
Next
From: Greg Smith
Date:
Subject: Re: Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?