Hallo,
Ich nutze postgres als Datenbank Server unter Windows 2008 R2, seit der Installation kommt es immer wieder zu crashs mit exit code 9. Google spuckte leider nicht die gewünschten ergebnisse aus.
Vllt könnt ihr mir helfen. Es läuft ein Symantec Viren Scanner, wo aber die Postgress ordner von dem Scannen rausgenommen sind.
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.
EDIT: es ist eine 32Bit installation von Postgres, alle anderen installation machen keine Probleme nur die.
Viele Grüße TK