Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: how can we resolving locking state....
Date
Msg-id 823.1281017444@sss.pgh.pa.us
Whole thread Raw
In response to how can we resolving locking state....  (노현석<noh019@naver.com>)
List pgsql-general
Tree view 
=?EUC-KR?B?s+vH9ryu?=<noh019@naver.com> writes:
> $ kill -9 5143

[ and all the other backends disappear too ]

> Could you teach me, Is this expected behavior ?

Yes.  That is not the recommended way to kill a backend.
Try pg_terminate_backend().

            regards, tom lane

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: how can we resolving locking state....
Next
From: "Richard"
Date:
Subject: Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?