From: barry@e-rm.co.uk
Subject: Replication
Date: 12 Sep 2005 04:52:05 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=217.154.196.234;
	posting-account=AiPuyQ0AAABDGZ9YfBXo6Ntgz0h9hgBS
To: pgsql-general@postgresql.org

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