From: Joshua D. Drake <jd@commandprompt.com>
To: barry@e-rm.co.uk
Cc: pgsql-general@postgresql.org
Subject: Re: Replication
Date: Mon, 12 Sep 2005 08:13:36 -0700
Message-ID: <43259B20.4040906@commandprompt.com> (raw)
In-Reply-To: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
References: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
barry@e-rm.co.uk wrote:
>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.
>
Actually the theorectical limit for the Mammoth system is 10,000 tables,
we have only tested up to 1000. This is metioned quite clearly on the
website.
It should be noted that if Slony-I won't do what you need then Mammoth
probably
would not either.
Although Mammoth can add new tables on the fly as long as those tables
are empty. If they are not empty they would cause a full sync to occur.
Sincerely,
Joshua D. Drake
>
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
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: jd@commandprompt.com, barry@e-rm.co.uk
Subject: Re: Replication
In-Reply-To: <43259B20.4040906@commandprompt.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