MIME-Version: 1.0
From: Jethish Jethish <jethish777@gmail.com>
Date: Thu, 23 May 2024 13:32:13 +0530
Message-ID: <CAKeSjMhHx1cMSTPTP7szhyV5Mt21YuA98Q+hS9+W2nrj0U9N3Q@mail.gmail.com>
Subject: Backup failure Postgres
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b8889b06191a78c4"
Archived-At: <https://www.postgresql.org/message-id/CAKeSjMhHx1cMSTPTP7szhyV5Mt21YuA98Q%2BhS9%2BW2nrj0U9N3Q%40mail.gmail.com>
Precedence: bulk

--000000000000b8889b06191a78c4
Content-Type: text/plain; charset="UTF-8"

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;

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

<div dir=3D"auto">I&#39;m frequently facing the below error while performin=
g backup. Someone please tell how solve this issues.<div dir=3D"auto"><br><=
/div><div dir=3D"auto"><br></div><div dir=3D"auto"><p style=3D"margin-top:0=
px;margin-bottom:0px">Failed : pg_dump: error: Dumping the contents of tabl=
e &quot;botsession&quot; failed: PQgetResult() failed. pg_dump: error: Erro=
r message from server: ERROR: canceling statement due to conflict with reco=
very DETAIL: User query might have needed to see row versions that must be =
removed. pg_dump: error: The command was: COPY public.botsession (id, useri=
d, data, iscompressed) TO stdout;</p></div></div>

--000000000000b8889b06191a78c4--