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

On Tue, Sep 28, 2021 at 7:39 PM Andrew Dunstan <andrew(at)dunslane(dot)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.