I am trying to get my head around why I keep getting crashes to my PG 8.3.7 database on CentOS - Linux version 2.6.18-164.el5. There are 3 slightly different (I think) circumstances leading to a crash of the database, all related in some way to long running PHP scripts with intensive activity on PG connections.
#1 - execution of an R call via pLR (sometimes this may crash it all by itself)
#2 - execution of a postGIS query (possible)
#3 - random occurences, all related to the same long running PHP scripts
I have read that perhaps hardware and/or system settings may cause this. I believe the system is running i9 processors, that may be set into some sort of virtual multi-threading mode. Thanks for any insight you all can give in tracking this down.
r.b.
Dump transcipt from postgresql log file:
LOG: server process (PID 5978) exited with exit code 2
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
<snip>message repeats 14 times </snip>
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2011-09-23 14:15:04 EDT
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 4AD/CFE63B98
LOG: record with zero length at 4AD/D0063FD8
LOG: redo done at 4AD/D0063FA8
LOG: last completed transaction was at log time 2011-09-23 14:19:45.972521-04
LOG: autovacuum launcher started
LOG: database system is ready to accept connections