Re: Confusing error message in 15.6

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Confusing error message in 15.6
Дата
Msg-id CAKFQuwaBvMX671=AUsuukkeU2hv0iSSA9=ixDXzBWM8WLCtRwg@mail.gmail.com
обсуждение исходный текст
Ответ на Confusing error message in 15.6  (Dmitry O Litvintsev <litvinse@fnal.gov>)
Ответы Re: Confusing error message in 15.6
Re: Confusing error message in 15.6
Список pgsql-general


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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitry O Litvintsev
Дата:
Сообщение: Confusing error message in 15.6
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Confusing error message in 15.6