promote a deferred standby without applying WALs

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: promote a deferred standby without applying WALs
Date: 2024-07-16 08:04:14
Message-ID: GV0P278MB009978C3836E51677017D2998BA22@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a standby database running 3 hours behind the primary (recovery_min_apply_delay = '3h').

In case of a logical error on the primary I want to promote the standby database which still has correct data.

The standby should not apply any more WAL in that case.

It seems that this can only be done manually:

1. pg_ctl stop
2. rm -rf standby.signal
3. set primary_conninfo = ''
4. pg_ctl start

Is there no single command on this?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-16 08:40:55 Re: promote a deferred standby without applying WALs
Previous Message Kashif Zeeshan 2024-07-16 07:01:01 Re: indexes on partitioned tables