Backup failure Postgres - Mailing list pgsql-general

From Jethish Jethish
Subject Backup failure Postgres
Date
Msg-id CAKeSjMhHx1cMSTPTP7szhyV5Mt21YuA98Q+hS9+W2nrj0U9N3Q@mail.gmail.com
Whole thread Raw
Responses Re: Backup failure Postgres
List pgsql-general
I'm frequently facing the below error while performing backup. Someone please tell how solve this issues.


Failed : pg_dump: error: Dumping the contents of table "botsession" failed: PQgetResult() failed. pg_dump: error: 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: error: The command was: COPY public.botsession (id, userid, data, iscompressed) TO stdout;

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Long running query causing XID limit breach
Next
From: Laurenz Albe
Date:
Subject: Re: Json table/column design question