| From: | Jan Wieck <jan(at)wi3ck(dot)info> |
|---|---|
| To: | basti <black(dot)fledermaus(at)arcor(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL Replication Server + repmgr + Slony |
| Date: | 2014-04-12 19:36:15 |
| Message-ID: | 534995AF.8090202@wi3ck.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Förtsch | 2014-04-13 10:58:31 | Why do we need an AccessExclusiveLock to validate a FK constraint marked as NOT VALID? |
| Previous Message | Jan Wieck | 2014-04-12 18:27:36 | Re: Cancelling of autovacuums considered harmful |