karol.malinowski@xxxxxxxxxxxxxx writes: > last week backup of my one database stops with error like below: > "pg_dump: [archiver (db)] query failed: server closed the connection > unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > Additional info: > PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-16), 64-bit The first thing I'd suggest is updating to the latest release in that branch (9.6.24). You're missing four years' worth of bug fixes, and it's not improbable that the underlying issue here is included in that. If that doesn't help, you'll need to start debugging. The symptom looks a bit like catalog corruption; if you are lucky then REINDEX'ing the catalogs used in that query would help. regards, tom lane
