Activate a standby database and then revert to standby

From: Massimo Ortensi <mortensi(at)unimaticaspa(dot)it>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Activate a standby database and then revert to standby
Date: 2021-10-28 09:12:10
Message-ID: 1mg1SF-000Mdb-9e@unimaticaspa.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I need to activate (open in read and write) a standby database, perform
some action and then revert it to the previous status of standby and
thus starting again loading wals from when it stopped.

How should I proceed to be sure it's possible to get "back in time" to
the standby db ?
It's a huge DB and can't afford restarting sync from scratch

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-10-28 09:41:07 Re: Activate a standby database and then revert to standby
Previous Message Michel SALAIS 2021-10-27 16:54:34 RE: Understanding was terminated by signal 9: Killed