MIME-Version: 1.0
References: <SA1PR09MB731160449C3C97197555F1F3B9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
In-Reply-To: <SA1PR09MB731160449C3C97197555F1F3B9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 21 May 2024 17:42:37 -0600
Message-ID: <CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com>
Subject: Re: Confusing error message in 15.6
To: Dmitry O Litvintsev <litvinse@fnal.gov>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000014652f0618ff60be"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaBvMX671%3DAUsuukkeU2hv0iSSA9%3DixDXzBWM8WLCtRwg%40mail.gmail.com>
Precedence: bulk

--00000000000014652f0618ff60be
Content-Type: text/plain; charset="UTF-8"

On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev <litvinse@fnal.gov> wrote:

> Hi,
>
> I am observing the following error which confuses me:
>
> #  psql -U postgres template1 -c "checkpoint; select
> pg_backup_start('${dest}.tar.Z', true)"
> CHECKPOINT
>  pg_backup_start
> -----------------
>  17BF7/3009498
> (1 row)
>
> #  psql -U postgres template1 -c "select pg_backup_stop(true)"
> ERROR:  backup is not in progress
> HINT:  Did you call pg_backup_start()?
>
> This is postgresql 15.6 running on RH 7.
>
> This is not just amusing, it is breaking my backup script after update
> from 11 to 15 (and change from pg_{start,stop}_backup to
> pg_backup_{start_stop})
>


Yep, nowadays you must keep the transaction where you issued backup start
open until you issue backup end.  Using -c isn't going to cut it.

David J.

>

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

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev &lt;<a=
 href=3D"mailto:litvinse@fnal.gov">litvinse@fnal.gov</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:=
1px #ccc solid;padding-left:1ex">Hi, <br>
<br>
I am observing the following error which confuses me:<br>
<br>
#=C2=A0 psql -U postgres template1 -c &quot;checkpoint; select pg_backup_st=
art(&#39;${dest}.tar.Z&#39;, true)&quot;<br>
CHECKPOINT<br>
=C2=A0pg_backup_start <br>
-----------------<br>
=C2=A017BF7/3009498<br>
(1 row)<br>
<br>
#=C2=A0 psql -U postgres template1 -c &quot;select pg_backup_stop(true)&quo=
t; <br>
ERROR:=C2=A0 backup is not in progress<br>
HINT:=C2=A0 Did you call pg_backup_start()?<br>
<br>
This is postgresql 15.6 running on RH 7. <br>
<br>
This is not just amusing, it is breaking my backup script after update from=
 11 to 15 (and change from pg_{start,stop}_backup to pg_backup_{start_stop}=
)<br></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto"=
><br></div><div dir=3D"auto">Yep, nowadays you must keep the transaction wh=
ere you issued backup start open until you issue backup end.=C2=A0 Using -c=
 isn&#39;t going to cut it.</div><div dir=3D"auto"><br></div><div dir=3D"au=
to">David J.</div><div dir=3D"auto"><div class=3D"gmail_quote"><blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid=
;padding-left:1ex"></blockquote></div></div></div>

--00000000000014652f0618ff60be--