Re: Replication mode - Mailing list pgsql-admin

From Satish
Subject Re: Replication mode
Date
Msg-id CAAnXASrAT=FhZp=-67njsBzNoSr6w3jjpn=kbhtN5QKPunoNew@mail.gmail.com
Whole thread Raw
In response to Re: Replication mode  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-admin
Urgent - Please unsubscribe satish.alreja@gmail.com from all Postgres lists.

On Wed, Jan 10, 2018 at 5:36 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:


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.




--
Satish

      
Ph: +1 (704) 464 0160 (Home)
       +1 (704) 464 0611 (Home)
       +1 (704) 960 0226 (Mob)
     
Do all the good you can, by all the means you can, in all the ways you can, in all the places you can, at all the times you can, to all the people you can, as long as ever you can.
- John Wesley

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Broken replication in 3 node setup, master halt,standby 1 promoted, standby 2 - replication not working
Next
From: scott ribe
Date:
Subject: Re: Replication mode