Re: pg_restore: error returned by PQputline

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore: error returned by PQputline
Date: 2004-08-30 01:49:45
Message-ID: 18666.1093830585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto(at)yahoo(dot)com(dot)br> writes:
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Akash Garg 2004-08-30 04:56:28 weird error during pg_dump
Previous Message Clodoaldo Pinto Neto 2004-08-30 01:40:29 Re: pg_restore: error returned by PQputline