Re: WAL Replication Server + repmgr + Slony - Mailing list pgsql-general

From Jan Wieck
Subject Re: WAL Replication Server + repmgr + Slony
Date
Msg-id 534995AF.8090202@wi3ck.info
Whole thread Raw
In response to WAL Replication Server + repmgr + Slony  (basti <black.fledermaus@arcor.de>)
List pgsql-general
On 03/20/14 10:37, basti wrote:
> Hello,
>
> at the moment we use a Postgres (9.1) Master and a Hot-Standby with WAL
> Replication.
>
> We also use Slony to copy some (not all) Tables to fronted server.
> Is it possible to use repmgr to switch between Master and Hot-standby
> without lose the slony functionality?
>
> When I use repmgr and switch between master and slave what's about
> IP-addresses and hostnames? Do I need a virtual IP that can I switch
> from one to the other server?

Unless your standby moves backwards in time (async replication and
failover losing transactions), all that is needed should be to issue
STORE PATH commands with the new IP/hostname to the Slony replica(s).


Regards,
Jan

--
Jan Wieck
Senior Software Engineer
http://slony.info


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Cancelling of autovacuums considered harmful
Next
From: Torsten Förtsch
Date:
Subject: Why do we need an AccessExclusiveLock to validate a FK constraint marked as NOT VALID?