Re: terminating connection because of crash of another server process

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sergio nogueira <sergiopnog(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: terminating connection because of crash of another server process
Date: 2009-06-14 15:03:35
Message-ID: 10900.1244991815@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sergio nogueira <sergiopnog(at)gmail(dot)com> writes:
> then i kill the process executing the truncate.
> the result:

> LOG: server process (PID 3421) was terminated by signal 9:
> Killed

> Any idea on how to prevent this?

Don't do that. kill -9 is *never* the recommended way to terminate a
query. Next time try kill -INT, if you must do something like this.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message APseudoUtopia 2009-06-14 15:14:04 Opinions on how to Integrate Transactions
Previous Message sergio nogueira 2009-06-14 14:53:45 terminating connection because of crash of another server process