On Fri, Oct 8, 2021 at 03:34:04PM -0700, Wells Oliver wrote: > Dug out some more logging: > > 2021-10-08 20:18:46 UTC::@:[27842]:LOG: checkpoint complete: wrote 43719 > buffers (8.3%); 0 WAL file(s) added, 0 removed, 842 recycled; write=3239.859 s, > sync=0.560 s, total=3242.821 s; sync files=67, longest=0.050 s, average=0.008 > s; distance=55175592 kB, estimate=55185037 kB > 2021-10-08 20:24:44 UTC::@:[27842]:LOG: checkpoint starting: time > 2021-10-08 20:35:08 UTC::@:[12682]:LOG: server process (PID 3970) was > terminated by signal 9: Killed ------------------------------ Ah, this line above is probably the out-of-memory killer, meaning you allocated too much memory and the operating system killed a backend process with kill -9, causing the server to have to restart. Reducing maintenance_work_mem is probably the right solution, or increase your RAM. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
