Re: terminating connection because of crash of another server process - Mailing list pgsql-general

sergio nogueira <sergiopnog@gmail.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