Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process
Date
Msg-id 5526.1383700304@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process  (robert@urban4m.com)
Responses Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process  (Robert Nix <robert@urban4m.com>)
List pgsql-bugs
Tree view 
robert@urban4m.com writes:
> 2013-11-05 17:04:21 EST LOG:  server process (PID 5869) was terminated by
> signal 9: Killed

OOM killer, almost certainly.  Check your kernel log to confirm.
Then read about preventing OOM kills:
http://www.postgresql.org/docs/9.3/static/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT

            regards, tom lane

pgsql-bugs by date:

Previous
From: robert@urban4m.com
Date:
Subject: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process
Next
From: Robert Nix
Date:
Subject: Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process