Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-19 Thread Craig Ringer
On 06/14/2011 10:26 PM, BangarRaju Vadapalli wrote: Hi Everybody, We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. Here are the logs. - Examination of the full

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-19 Thread BangarRaju Vadapalli
Answers Below -Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Sunday, June 19, 2011 3:03 PM To: BangarRaju Vadapalli Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released

[GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-14 Thread BangarRaju Vadapalli
Hi Everybody, We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. Here are the logs. 2011-06-14 18:06:04 IST WARNING: terminating connection because of

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-14 Thread Merlin Moncure
On Tue, Jun 14, 2011 at 9:26 AM, BangarRaju Vadapalli bangarraju.vadapa...@infor.com wrote: Hi Everybody,   We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-14 Thread Craig Ringer
On 06/14/2011 10:26 PM, BangarRaju Vadapalli wrote: Hi Everybody, We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. Here are the logs. Thankyou for collecting

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-14 Thread Craig Ringer
On 15/06/2011 7:50 AM, Craig Ringer wrote: There's no reason it can't be compiled for PostgreSQL 8.4, though I never tested that. It shouldn't take long so I'll give it a go and get back to you. Okies. I've built a version for 8.4. You can download it (32-bit only) from:

Re: [GENERAL] random backend crashes - how to debug ( Is crash dump handler released ? )

2011-06-14 Thread Craig Ringer
On 15/06/2011 7:50 AM, Craig Ringer wrote: I searched online and found crash dump handler idea has been proposed and patch for that has already been released if I am not wrong. It is integrated into PostgreSQL 9.0 as a core part of the server. Correction - it's in 9.1 not 9.0 . Whoops, I