From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Replication Question |
Date: | 2016-01-28 17:04:15 |
Message-ID: | 20160128170415.GA6483@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bala Venkat <akpgeek(at)gmail(dot)com> wrote:
> Hi there -
>
> We have a set up where there is One master streaming to 3 Slaves .
> 2 slaves are in our DR environment. One is the prod environment.
>
> Wanted to make the DR as primary. I know we can make the one of the
> slave in DR to primary. If I want to keep the other slave as slave connecting
> to the new Master DR , is it possible ? or I have to set the whole streaming
> process again in DR ? Can you please share your experience ?
should be possible, but you have to change the recovery.conf to point
out to the new master, and, of course, the new master should stream the
wals (wal_sender, proper pg_hba.conf and so on).
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-01-28 17:10:35 | BRIN indexes |
Previous Message | Kaushal Shriyan | 2016-01-28 17:03:26 | Re: Difference between UDR and BDR replication |