On Tue, Sep 4, 2012 at 7:21 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote: >> >> BTW, after I signalled TERM, the process status changed from >> >> notify interrupt waiting >> >> to >> >> notify interrupt waiting waiting >> >> which I thought looked kind of odd. >> >> Then I signalled KILL. > > > was this a client process or a postgres process? kill -9 on postgres > processes can easily trigger data corruption. This was a postgres process. i certainly won't signal KILL anymore to postgres processes, thanks for that warning, John. Aleksey -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general