Streaming replication and Timelines

From: Serge Dubrouski <sergeyfd(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Streaming replication and Timelines
Date: 2011-02-25 16:22:51
Message-ID: AANLkTimDJmd1Gnny-O+Ahj1m=ZkK8OnV+F34ucjKmTu3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello -

I'm trying to implement Streaming replication with several Hot-Standby
servers and floating IP for the Master Server. I mean when Master
server fails IP gets switched to the new Master and all standby
servers start receiving log data from the new Master. My problem
though is timelines. Whenever Stansby server gets triggered from
Stansby role to Master role it increases Timeline and that kind of
invalidates all other Standbys. They start to complain on mismatching
Timeline. The only way to fix them is to switch new Master into Backup
mode and resync al Standbys. On other hand if I don't use trigger file
and just stop Standby, remove recovery.conf file and start it back,
all other Standbys keep working well, but I'm not sure how safe is
this strategy. So the question if it's possible to avoid increasing
Timelines when trigger file is used.

Thanks.

--
Serge Dubrouski.

Browse pgsql-admin by date

  From Date Subject
Next Message Vaughn, Adam (IMS) 2011-02-25 19:50:06 long running commits
Previous Message Tom Lane 2011-02-25 05:45:08 Re: questions about the configure script for building postgres 9.0.3 from source