Message-ID: <43259B20.4040906@commandprompt.com>
Date: Mon, 12 Sep 2005 08:13:36 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727)
MIME-Version: 1.0
To: barry@e-rm.co.uk
Cc: pgsql-general@postgresql.org
Subject: Re: Replication
References: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
In-Reply-To: <1126525925.103304.219710@g44g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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/