MIME-Version: 1.0
From: =?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQpNGA0L7Qu9C+0LI=?= <frolov.vova@gmail.com>
Date: Thu, 23 Apr 2026 18:17:32 +0300
Message-ID: <CADi=iLRqiz4qD_DoG225D=HtQLPx56HF=D2WcYGGRxx8g0TK0Q@mail.gmail.com>
Subject: pg_dumpall bug exit code 0 with fatal
To: pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007235dd065022266b"
Archived-At: <https://www.postgresql.org/message-id/CADi%3DiLRqiz4qD_DoG225D%3DHtQLPx56HF%3DD2WcYGGRxx8g0TK0Q%40mail.gmail.com>
Precedence: bulk

--0000000000007235dd065022266b
Content-Type: text/plain; charset="UTF-8"

 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 (

--0000000000007235dd065022266b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">=C2=A0I have installed t=
wo nodes cluster- PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-li=
nux-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 -=C2=A0<br>pg_dump: erro=
r: Dumping the contents of table &quot;*****&quot; failed: PQgetResult() fa=
iled.<br>pg_dump: detail: Error message from server: ERROR: =C2=A0canceling=
 statement due to conflict with recovery<br>DETAIL: =C2=A0User query might =
have needed to see row versions that must be removed.<br>pg_dump: detail: C=
ommand was: COPY **** ( **** ) TO stdout;<br>pg_dumpall: error: pg_dump fai=
led on database &quot;**********&quot;, exiting<br>it is normal, BUT! exit =
code is 0!=C2=A0 In my backup script tell OK to this task. Monitoring tell =
ok, but backup=C2=A0is empty (=C2=A0=C2=A0</div>
</div>
</div>

--0000000000007235dd065022266b--