Re: pg_restore: error returned by PQputline - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore: error returned by PQputline
Date
Msg-id 18666.1093830585@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore: error returned by PQputline  (Clodoaldo Pinto Neto <clodoaldo_pinto@yahoo.com.br>)
Responses Re: pg_restore: error returned by PQputline  (Richard Huxton <dev@archonet.com>)
Re: pg_restore: error returned by PQputline  (Clodoaldo Pinto Neto <clodoaldo_pinto@yahoo.com.br>)
Re: pg_restore: error returned by PQputline  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto@yahoo.com.br> writes:
>  --- Tom Lane <tgl@sss.pgh.pa.us> escreveu:
>> Look in the postmaster's log to see what happened.

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

Well, there's a smoking gun ...

Assuming that you didn't deliberately kill -9 your server process,
the only mechanism I've heard of that causes this is the Linux kernel's
out-of-memory killer --- see
http://www.postgresql.org/docs/7.4/static/kernel-resources.html#AEN17068
Googling for "OOM kill" will give you additional gory details :-(.

            regards, tom lane

pgsql-general by date:

Previous
From: Clodoaldo Pinto Neto
Date:
Subject: Re: pg_restore: error returned by PQputline
Next
From: Akash Garg
Date:
Subject: weird error during pg_dump