Re: Replication mode

Поиск
Список
Период
Сортировка
От Satish
Тема Re: Replication mode
Дата
Msg-id CAAnXASrAT=FhZp=-67njsBzNoSr6w3jjpn=kbhtN5QKPunoNew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication mode  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список 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 по дате отправления:

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: Broken replication in 3 node setup, master halt,standby 1 promoted, standby 2 - replication not working
Следующее
От: scott ribe
Дата:
Сообщение: Re: Replication mode