Re: Confusing error message in 15.6 - Mailing list pgsql-general

From Dmitry O Litvintsev
Subject Re: Confusing error message in 15.6
Date
Msg-id SA1PR09MB7311DDDF1550079AD61D9D7FB9EA2@SA1PR09MB7311.namprd09.prod.outlook.com
Whole thread Raw
In response to Re: Confusing error message in 15.6  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Confusing error message in 15.6
List 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.g.johnston@gmail.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@fnal.gov<mailto: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}_backupto 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'tgoing to cut it. 

David J.



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Confusing error message in 15.6
Next
From: Sašo Gantar
Date:
Subject: Re: problem with query