Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8BABD64FD04 for ; Thu, 21 Aug 2008 18:42:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48164-09 for ; Thu, 21 Aug 2008 18:42:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id 62CBF64FCFF for ; Thu, 21 Aug 2008 18:42:06 -0300 (ADT) Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id DADFC4A3C for ; Thu, 21 Aug 2008 14:42:00 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: The state of PG replication in 2008/Q2? Date: Thu, 21 Aug 2008 14:41:59 -0700 User-Agent: KMail/1.9.9 References: <48ADABAF.8030602@drivefaster.net> <48ADDD9F.2090505@quietcaresystems.com> In-Reply-To: <48ADDD9F.2090505@quietcaresystems.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200808211441.59401@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200808/266 X-Sequence-Number: 31147 On Thursday 21 August 2008, salman wrote: > Mathias Stjernstr=F6m wrote: > > Yes thats true. It does support DDL changes but not in a automatic way. > > You have to execute all DDL changes with a separate script. > > That's true, but it's quite simple to do with the provided perl > script(s) - slonik_execute_script. I've had to make use of it a few > times and have had no problems. I do it almost every day, and it is not all that simple if your=20 configuration is complex. The original poster would require at least 47=20 different Slony clusters, for starters. The complications from adding and=20 dropping tables and sequences across 47 databases, and trying to keep Slony= =20 up to date throughout, staggers the imagination, honestly. =2D-=20 Alan