From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Dmitry O Litvintsev <litvinse(at)fnal(dot)gov> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Confusing error message in 15.6 |
Date: | 2024-05-21 23:42:37 |
Message-ID: | CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev <litvinse(at)fnal(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2024-05-21 23:50:14 | Re: Confusing error message in 15.6 |
Previous Message | Dmitry O Litvintsev | 2024-05-21 23:29:24 | Confusing error message in 15.6 |