Hello Guys I have following situation:
PostgreSQL Database 9.1 32 Bit is crashing immediately, it's an Windows 2008R2. I have patched to 9.2 64Bit, but is crashing with the same Exit code What is "exit code 9"?? Here is an cut from the postgres.log 013-01-31 14:42:08 CETCONTEXT: automatic vacuum of table "cloud.public.m201301_devicestatus"2013-01-31 14:43:14 CETLOG: server process (PID 5820) exited with exit code 9 2013-01-31 14:43:14 CETLOG: terminating any other active server processes 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process 2013-01-31 14:43:14 CETDETAIL: 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. 2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command. 2013-01-31 14:43:15 CETLOG: all server processes terminated; reinitializing 2013-01-31 14:43:24 CETFATAL: pre-existing shared memory block is still in use 2013-01-31 14:43:24 CETHINT: Check if there are any old server processes still running, and terminate them. We have an active antivirus scanner, but we excluding the PostgreSQL folders where are the data folder locate is. Hope any one can help Best regards Tony
