Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 57752650094 for ; Thu, 21 Aug 2008 18:21:34 -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 33603-01 for ; Thu, 21 Aug 2008 18:21:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from globalinn.com (mail.globalinn.se [80.75.24.2]) by postgresql.org (Postfix) with ESMTP id 1CE6F64FFEC for ; Thu, 21 Aug 2008 18:21:29 -0300 (ADT) X-Antivirus-Scanned: McAfee Received: from [217.210.59.25] (account mathias HELO [10.0.1.200]) by globalinn.com (CommuniGate Pro SMTP 5.0.11) with ESMTPSA id 33144741 for pgsql-performance@postgresql.org; Thu, 21 Aug 2008 23:21:27 +0200 Message-Id: From: =?ISO-8859-1?Q?Mathias_Stjernstr=F6m?= To: pgsql-performance@postgresql.org In-Reply-To: <20080821210435.GN307@commandprompt.com> Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha1; boundary="Apple-Mail-14-528318149" Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v928.1) Subject: Re: The state of PG replication in 2008/Q2? Date: Thu, 21 Aug 2008 23:21:26 +0200 References: <48ADABAF.8030602@drivefaster.net> <20080821210435.GN307@commandprompt.com> X-Pgp-Agent: GPGMail d53 (v53, Leopard) X-Mailer: Apple Mail (2.928.1) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, RCVD_IN_DNSWL_LOW=-1, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200808/263 X-Sequence-Number: 31144 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --Apple-Mail-14-528318149 Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Yes thats true. It does support DDL changes but not in a automatic =20 way. You have to execute all DDL changes with a separate script. What's the status of = http://www.commandprompt.com/products/mammothreplicator/=20 ? Best regards, Mathias http://www.pastbedti.me/ On 21 aug 2008, at 23.04, Andrew Sullivan wrote: > On Thu, Aug 21, 2008 at 10:53:05PM +0200, Mathias Stjernstr=F6m wrote: > >> For Master-Slave replication i think that Slony = http://www.slony.info/=20 >> is >> most up to date. But it does not support DDL changes. > > This isn't quite true. It supports DDL; it just doesn't support it in > the normal way, and is broken by applications doing DDL as part of the > regular operation. > > A > > --=20 > Andrew Sullivan > ajs@commandprompt.com > +1 503 667 4564 x104 > http://www.commandprompt.com/ > > --=20 > Sent via pgsql-performance mailing list = (pgsql-performance@postgresql.org=20 > ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance --Apple-Mail-14-528318149 content-type: application/pgp-signature; x-mac-type=70674453; name=PGP.sig content-description: This is a digitally signed message part content-disposition: inline; filename=PGP.sig content-transfer-encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) iQEcBAEBAgAGBQJIrdxWAAoJEMkN6DtuoU6XkpkIAIv7ZJNfRj7qqrBsdFl4NTDh NlhsJ4hEZNa4mTg3k9GU7seimV6C0Zu9wGf8fHPe+xxRfSByMCcpQ2UZaXTNo1/n JwBFTj72j9FognF8zJXk25yZbfOkPX5XFNRywBRcHvo1iOypM0SWfKz+t+yQ8Fiv sdHykgU6I9/NDaqRtPGBQHMzLRytrEHZqCeX6MoWEeGh5OAacltOwb0cfLt8ADpf Hfo9BE+mu+t7bfQqwOZ6auk7d/j9J5EJ8uonA3mHVTnCnKfyfTXvwmyLer0FnOQS eROHYz+55S5YZ66nNm4H9SWi6WQe/LM+xZEA/GVp0jBeaFR8whjAkNlY8s2BeQ8= =p7de -----END PGP SIGNATURE----- --Apple-Mail-14-528318149--