Re: [GENERAL] cluster question

Поиск
Список
Период
Сортировка
От Alex Samad
Тема Re: [GENERAL] cluster question
Дата
Msg-id CAJ+Q1PUytXa3onDWiRmZOE=N2Def7JY9wu-+D-hpgO+DDpHAJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] cluster question  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: [GENERAL] cluster question  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Hi

Quick question.  I have a 2 node cluster - each node has its own ip.

But from reading this, I really need a 3rd ip, which potentially floats between the nodes to which ever is the master / rw node.

Is that right? Sort of makes sense I guess

A

On 14 August 2017 at 16:47, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:
On 14 August 2017 08:39:54 GMT+02:00, Alex Samad <alex@samad.com.au> wrote:
>Hi
>
>I have setup a streaming replicating cluster, with a hot standby.
>
>Now I would like to change the RW to hot standby and change the hot
>standby
>to be the RW server.
>
>Is it just a matter of updating recover.conf file ?
>
>Alex

I would suggest you repmgr, with this tool you can do "repmgr standby switchover" to perform such tasks.

Regards, Andreas.


--
2ndQuadrant - The PostgreSQL Support Company

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] WAL replication wrong collate
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [GENERAL] cluster question