Search Postgresql Archives

Re: how can we resolving locking state ....

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Please post in plain text if possible.

2010/8/5 노현석 <noh019@xxxxxxxxx>
>
> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux