PostgreSQL: checkpointer process was terminated by signal 9: killed

[Konrad Garus]

Hello,

in the last couple weeks my Postgres instance went down a few times. I found the following messages in the logs, but can't put my finger on what the root cause may be.

Is this some known issue? What else can I do to troubleshoot?

[16-1] db=,user= LOG: checkpointer process (PID 645146) was terminated by signal 9: Killed

[17-1] db=,user= LOG: terminating any other active server processes

[2-1] db=,user= WARNING: terminating connection because of crash of another server process

[3-1] db=,user= 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.

[4-1] db=,user= HINT: In a moment you should be able to reconnect to the database and repeat your command.

[yananc]

Hi,

The logs do not provide much information about the cause of the issue. More details may be needed in order to further investigate. That being said, similar issues are often caused by OOM. Have you checked the memory usage and other resource consumption for any abnormality before the instance went down?