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

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: how to distinguish between using the server as a standby or for executing a targeted recovery in PG 11?
Дата
Msg-id CALj2ACX2cA4DfKe-5RHFaiM-Xd-K-3j5a7a4dGr+vwwgUVRbBg@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Список 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 по дате отправления:

Предыдущее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: Added schema level support for publication.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Added schema level support for publication.