From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Azimuddin Mohammed <azimeiu@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Replication mode
Date: Thu, 11 Jan 2018 11:36:28 +1300
Message-ID: <ccca8eb3-60aa-d942-31fb-ee3a9cb66a6d@catalyst.net.nz> (raw)
In-Reply-To: <eb965246-4bba-a47e-b939-a6279c632c7b@catalyst.net.nz>
References: <CAKUuFd5rq4k0HnPYOf0AuUrSRaL-iNwPYFe=e84qmtwrBMG+Gg@mail.gmail.com>
<ec6b33ee-e6da-bde5-5c42-c15b847a5b30@2ndquadrant.com>
<eb965246-4bba-a47e-b939-a6279c632c7b@catalyst.net.nz>
On 11/01/18 11:11, Mark Kirkwood wrote:
>
>
> ...altho we do not precisely say how to setup this up as opposed to
> the 'hot' variant. In fact it is pretty easy to (accidentally) get a
> warm standby by forgetting to set :
>
> standby_mode = 'on'
>
> in recovery.conf
>
Sorry - the above is completely wrong, should have said: setting
hot_standby = 'off'
in postgresql.conf gets you a 'warm' variant.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, peter.eisentraut@2ndquadrant.com, azimeiu@gmail.com
Subject: Re: Replication mode
In-Reply-To: <ccca8eb3-60aa-d942-31fb-ee3a9cb66a6d@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox