Re: pg_dump query failed

2022-07-28 Thread Tom Lane
karol.malinow...@trustedeyes.pl 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. > Addi

Re: pg_dump query failed

2022-07-28 Thread Ron
On 7/28/22 05:08, karol.malinow...@trustedeyes.pl wrote: Hi all, 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

Re: pg_dump query failed

2022-07-28 Thread David G. Johnston
On Thursday, July 28, 2022, wrote: > 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 > > database size 220GB > > System CentOS 7 > > I am not sure how to recognize the problem. > Does the server log have more info?

pg_dump query failed

2022-07-28 Thread karol . malinowski
Hi all, 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. pg_dump: [archiver (db)] query was: SELECT l.o