public inbox for [email protected]  
help / color / mirror / Atom feed
From: Владимир Фролов <[email protected]>
To: [email protected]
Subject: pg_dumpall bug exit code 0 with fatal
Date: Thu, 23 Apr 2026 18:17:32 +0300
Message-ID: <CADi=iLRqiz4qD_DoG225D=HtQLPx56HF=D2WcYGGRxx8g0TK0Q@mail.gmail.com> (raw)

 I have installed two nodes cluster- PostgreSQL 16.3 (Debian
16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian
12.2.0-14) 12.2.0, 64-bit with wal logical replication. When i run
pgdump_all - i have error -
pg_dump: error: Dumping the contents of table "*****" failed: PQgetResult()
failed.
pg_dump: detail: Error message from server: ERROR:  canceling statement due
to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be
removed.
pg_dump: detail: Command was: COPY **** ( **** ) TO stdout;
pg_dumpall: error: pg_dump failed on database "**********", exiting
it is normal, BUT! exit code is 0!  In my backup script tell OK to this
task. Monitoring tell ok, but backup is empty (


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pg_dumpall bug exit code 0 with fatal
  In-Reply-To: <CADi=iLRqiz4qD_DoG225D=HtQLPx56HF=D2WcYGGRxx8g0TK0Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox