Re: [GENERAL] Understand this error

2009-05-01 Thread Tom Lane
Craig Ringer writes: > Note that it's not very likely that PostgreSQL was the process that used > up all your memory. It was just unlucky enough to be picked as the one > to be killed, because the OOM killer is terrible at estimating which > process is using the most memory when programs like Post

Re: [GENERAL] Understand this error

2009-05-01 Thread Dennis Brakhane
On Thu, Apr 30, 2009 at 3:00 PM, paulo matadr wrote: > Hi all, > my database entry in mode recovery, > analyzing my pg_log I seem this: > system logger process (PID 6517) was terminated by signal 9 > background writer process (PID 6519) was terminated by signal 9 > terminating any other active ser

Re: [GENERAL] Understand this error

2009-05-01 Thread Craig Ringer
paulo matadr wrote: > Hi all, > my database entry in mode recovery, > analyzing my pg_log I seem this: > > system logger process (PID 6517) was terminated by signal 9 > background writer process (PID 6519) was terminated by signal 9 > terminating any other active server processes You haven't told

Re: [GENERAL] Understand this error

2009-04-30 Thread Scott Marlowe
On Thu, Apr 30, 2009 at 7:00 AM, paulo matadr wrote: > Hi all, > my database entry in mode recovery, > analyzing my pg_log I seem this: > system logger process (PID 6517) was terminated by signal 9 > background writer process (PID 6519) was terminated by signal 9 > terminating any other active ser

[GENERAL] Understand this error

2009-04-30 Thread paulo matadr
Hi all, my database entry in mode recovery, analyzing my pg_log I seem this: system logger process (PID 6517) was terminated by signal 9 background writer process (PID 6519) was terminated by signal 9 terminating any other active server processes and OS in var/logs: kernel: [] out_of_memory+0x