Hot Standby switchover

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Hot Standby switchover
Date: 2010-06-22 05:33:40
Message-ID: AANLkTinHxiPYFoWumfSw-TChv3acHds-rQ2MYo7-rJyU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Just been trying to learn hot-standby and couldn't figure out a solution to
something like this while doing a switchover:

I have three nodes where

A = Master
B = Slave1
C = Slave2

Now Hot-Standby is setup like this...

A --> B
A --> C

Now if I will like to do a switch so as to make B the new master and have my
replication look like this:

B --> C
B --> A

Where are the steps I need for doing so?

Thanks,
--
Shoaib Mir
http://shoaibmir.wordpress.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-06-22 05:36:22 Re: High Availability with Postgres
Previous Message John R Pierce 2010-06-22 05:24:47 Re: High Availability with Postgres