Re: Recover from failover

From: Martin S <martins(dot)listz(at)gmail(dot)com>
To: "white(dot)heron white" <white(dot)heron(at)yahoo(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Recover from failover
Date: 2011-12-06 15:38:48
Message-ID: CAFTQ5y3PYJXNdxCCeJe3L7w6eN1EaGPg5CTYs4fo8JoB2+Bcrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Dec 5, 2011 at 11:58 PM, white.heron white
<white(dot)heron(at)yahoo(dot)com> wrote:
> Dear All,
>
> As soon as the slave database server had been promoted to master. The
> old-server master database should be promote to become slave server.
> I believe database replication has been done by your vendor. In this case
> the new master database server will replicate data with new slave database
> server.
> Once replication completed. You may unplug the new slave database server and
> perform kernel operating system upgrade as standalone.
>
>
> Regards,
>
> MOHAMMAD ADLI BIN MT TAJUDIN
>
> H/p number:  (017) 362 3661
> Email: white(dot)heron(at)yahoo(dot)com

Thanks for the replies guys.

I like your approach Jerry. Promoting the slave and configuring the
master to be slave before going down, so when ex-master comes up, it
gets updated.
Problem here seems to be changing configs for maintenance. One error
and you are screwed. Probably creating some script to make it more
automatic or something could be a good idea.

Cheers!

Martin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Bruce - Postgres 2011-12-06 18:27:46 Postgres recommended by a SQL Server DBA
Previous Message white.heron white 2011-12-06 02:58:59 Re: Recover from failover