Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1eZP1O-00022K-KS
	for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jan 2018 22:38:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1eZP1O-0006qF-5X
	for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jan 2018 22:38:58 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <mark.kirkwood@catalyst.net.nz>)
	id 1eZOzE-00021X-Hn
	for pgsql-admin@lists.postgresql.org; Wed, 10 Jan 2018 22:36:44 +0000
Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <mark.kirkwood@catalyst.net.nz>)
	id 1eZOz9-0004Rg-Nt
	for pgsql-admin@postgresql.org; Wed, 10 Jan 2018 22:36:43 +0000
Received: from [IPv6:2406:e001:f09:1:70c3:90ad:f089:d084] (unknown
 [IPv6:2406:e001:f09:1:70c3:90ad:f089:d084])
	(Authenticated sender: mark.kirkwood@catalyst.net.nz)
	by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id
 1EAE180A68;
	Thu, 11 Jan 2018 11:36:29 +1300 (NZDT)
Subject: Re: Replication mode
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
 Azimuddin Mohammed <azimeiu@gmail.com>, pgsql-admin@postgresql.org
References: 
 <CAKUuFd5rq4k0HnPYOf0AuUrSRaL-iNwPYFe=e84qmtwrBMG+Gg@mail.gmail.com>
 <ec6b33ee-e6da-bde5-5c42-c15b847a5b30@2ndquadrant.com>
 <eb965246-4bba-a47e-b939-a6279c632c7b@catalyst.net.nz>
Message-ID: <ccca8eb3-60aa-d942-31fb-ee3a9cb66a6d@catalyst.net.nz>
Date: Thu, 11 Jan 2018 11:36:28 +1300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.5.0
MIME-Version: 1.0
In-Reply-To: <eb965246-4bba-a47e-b939-a6279c632c7b@catalyst.net.nz>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Authentication-Results: auth=pass smtp.auth=mark.kirkwood@catalyst.net.nz
 smtp.mailfrom=mark.kirkwood@catalyst.net.nz
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk



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.