public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Dmitry O Litvintsev <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Confusing error message in 15.6
Date: Wed, 22 May 2024 09:29:16 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
References: <SA1PR09MB731160449C3C97197555F1F3B9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
<CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com>
<SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2@SA1PR09MB7311.namprd09.prod.outlook.com>
On Tue, 2024-05-21 at 23:58 +0000, Dmitry O Litvintsev wrote:
> > > 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.
> >
> > 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.
>
> Oops. This means major rewrite of my backup procedure. Thanks for pointing
> this out. I will likely just switch to pg_basebackup. What I have is
> something old and gnarly from the days of psql version 8.
You could try https://github.com/cybertec-postgresql/safe-backup
to make the transition smoother.
Yours,
Laurenz Albe
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Confusing error message in 15.6
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox