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 crash of another server process
2011-06-14 18:06:04 IST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 IST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 IST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2011-06-14 18:06:04 IST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-06-14 18:06:04 IST WARNING: terminating connection because of crash of another server process
2011-06-14 18:06:04 IST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
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. Could anyone please detail the steps to install crash dump handler in windows? Also could you please help me with the ways to debug the crashes happening as shown above.
Thanks,
Bangar Raju