Re: Replication mode

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Azimuddin Mohammed <azimeiu(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication mode
Date: 2018-01-10 22:36:28
Message-ID: ccca8eb3-60aa-d942-31fb-ee3a9cb66a6d@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-01-10 22:39:01 Re: Broken replication in 3 node setup, master halt, standby 1 promoted, standby 2 - replication not working
Previous Message Azimuddin Mohammed 2018-01-10 22:17:41 Re: Replication mode