From: | Alex Samad <alex(at)samad(dot)com(dot)au> |
---|---|
To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: cluster question |
Date: | 2017-08-15 03:15:13 |
Message-ID: | CAJ+Q1PUytXa3onDWiRmZOE=N2Def7JY9wu-+D-hpgO+DDpHAJg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)a-kretschmer(dot)de>
wrote:
> On 14 August 2017 08:39:54 GMT+02:00, Alex Samad <alex(at)samad(dot)com(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2017-08-15 06:35:38 | Re: cluster question |
Previous Message | Michael Paquier | 2017-08-15 02:13:47 | Re: WAL replication wrong collate |