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 по дате отправления: