Re: how to distinguish between using the server as a standby or for executing a targeted recovery in PG 11? - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: how to distinguish between using the server as a standby or for executing a targeted recovery in PG 11?
Date
Msg-id CALj2ACX2cA4DfKe-5RHFaiM-Xd-K-3j5a7a4dGr+vwwgUVRbBg@mail.gmail.com
Whole thread Raw
In response to Re: how to distinguish between using the server as a standby or for executing a targeted recovery in PG 11?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Tue, Sep 28, 2021 at 7:39 PM Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> On 9/24/21 12:46 PM, Bharath Rupireddy wrote:
> > Hi,
> >
> > I'm trying to set up a postgres server with version 11 in targeted
> > recovery mode (for the first time after my journey started with
> > postgres) and I came across the explanation at [1] in PG 12 and newer
> > versions that we have a clear differentiation as to what is the
> > "standby" mode or "targeted recovery" mode. How do we differentiate
> > these two modes in PG 11? Can anyone please help me with it?
> >
> > PS: hackers-list may not be the right place to ask, but I'm used to
> > seeking help from it.
> >
>
>
> see <https://www.postgresql.org/docs/11/recovery-target-settings.html>
> and <https://www.postgresql.org/docs/11/standby-settings.html>

Thanks! It looks like the 'standby_mode = off' in the recovery.conf
with a 'recovery_target' makes the server to be in "targeted recovery"
mode.

Regards,
Bharath Rupireddy.



pgsql-hackers by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Added schema level support for publication.
Next
From: Amit Kapila
Date:
Subject: Re: Added schema level support for publication.