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 (