From: | Dmitry O Litvintsev <litvinse(at)fnal(dot)gov> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
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:58:42 |
Message-ID: | SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2@SA1PR09MB7311.namprd09.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
________________________________________
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Tuesday, May 21, 2024 6:42 PM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Confusing error message in 15.6
[EXTERNAL] – This message is from an external sender
On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev <litvinse(at)fnal(dot)gov<mailto: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 | Sašo Gantar | 2024-05-22 04:04:56 | Re: problem with query |
Previous Message | David G. Johnston | 2024-05-21 23:50:14 | Re: Confusing error message in 15.6 |