recovery.signal not being removed when recovery complete

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: recovery.signal not being removed when recovery complete
Date: 2024-03-26 22:22:32
Message-ID: CAMsGm5dbUPS+3NTJdVvnnvjdSDPk3f+ztxw+yXv56FJa5sdkEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use a script to restore a backup to create a testing copy of the
database. I set the following in postgresql.auto.conf:

recovery_target = 'immediate'
recovery_target_action = 'promote'

In the logs I get "recovery stopping after reaching consistency" then a
moment later "database system is ready to accept read-only connections",
then some entries about restoring log files, then "database system is ready
to accept connections".

I am able to make changes (e.g. CREATE TABLE), yet recovery.signal is still
present. My understanding is that recovery.signal should be removed when
recovery is finished (i.e., more or less when "database system is ready to
accept connections" is logged?), unless recovery_target_action is set to
'shutdown'.

Any ideas? Even just confirming/denying I understand the above correctly
would help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bandi, Venkataramana - Dell Team 2024-03-27 04:48:05 RE: Query on Postgres SQL transaction
Previous Message Nathan Bossart 2024-03-26 19:49:25 Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs