Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] cluster question - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] cluster question
Date
Msg-id C94765B4-E60F-45B3-93BA-FC2E82DD067D@a-kretschmer.de
Whole thread Raw
In response to [GENERAL] cluster question  (Alex Samad <alex@samad.com.au>)
Responses Re: [GENERAL] cluster question  (Alex Samad <alex@samad.com.au>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Alex Samad
Date:
Subject: [GENERAL] cluster question
Next
From: Arthur Zakirov
Date:
Subject: Re: [GENERAL] Where is pg_hba.conf