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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: how to distinguish between using the server as a standby or for executing a targeted recovery in PG 11?
Date: 2021-09-28 14:09:40
Message-ID: 49a3b87c-d210-d735-afcc-378817abd84e@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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>

(And yes, pgsql-general would be the right forum)

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2021-09-28 14:15:22 reindexdb usage message about system catalogs
Previous Message Antonin Houska 2021-09-28 14:08:27 Re: POC: Cleaning up orphaned files using undo logs