From: barry@e-rm.co.uk
To: pgsql-general@postgresql.org
Subject: Replication
Date: 12 Sep 2005 04:52:05 -0700
Message-ID: <1126525925.103304.219710@g44g2000cwa.googlegroups.com> (raw)
Hi,
I currently have a postgresql 8 system which I want to replicate
(ideally in realtime) with a spare host in order to introduce some
redundancy - eg. if the master server dies then I've got a ready-to-go
backup. Switchover does not have to be automated.
I've looked into commandprompt.com's mammoth system, but it only
supports up to 1000 tables (the documentation doesn't mention this!) -
the database in question has more than 1000 tables, and adds new tables
regularly. Slony-I and pgpool apparently don't support dynamic
schemas, which I'd obviously need, so they're not quite up to the job
either.
I'm currently looking at some sort of hack-job with the WAL archives
(see http://www.issociate.de/board/index.php?t=msg&goto=443099), but
this looks like a slightly flaky approach - have I missed the obvious
solution? Is there any stable software available which can replicate a
large and dynamic number of tables?
Cheers,
Barry
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: barry@e-rm.co.uk
Subject: Re: Replication
In-Reply-To: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox