Confusing error message in 15.6

From: Dmitry O Litvintsev <litvinse(at)fnal(dot)gov>
To: pgsql-generallists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Confusing error message in 15.6
Date: 2024-05-21 23:29:24
Message-ID: SA1PR09MB731160449C3C97197555F1F3B9EA2@SA1PR09MB7311.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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})

Thanks,
Dmitry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-05-21 23:42:37 Re: Confusing error message in 15.6
Previous Message Adrian Klaver 2024-05-21 21:52:03 Re: Restore of a reference database kills the auto analyze processing.