X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 717DA9FB31C for ; Tue, 1 Aug 2006 12:02:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31312-06 for ; Tue, 1 Aug 2006 12:02:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 73A109FB200 for ; Tue, 1 Aug 2006 12:02:16 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1G7vl9-0005iM-9o; Tue, 01 Aug 2006 11:02:15 -0400 Subject: Re: Cascading replication From: Brad Nicholson To: Thomas =?ISO-8859-1?Q?G=FCnther?= Cc: pgsql-admin@postgresql.org In-Reply-To: <011401c6b53b$40025370$2b00a8c0@imsfirmen.de> References: <011401c6b53b$40025370$2b00a8c0@imsfirmen.de> Content-Type: text/plain; charset=ISO-8859-1 Date: Tue, 01 Aug 2006 11:02:14 -0400 Message-Id: <1154444535.2624.1.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: quoted-printable X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.495 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200608/7 X-Sequence-Number: 22551 On Tue, 2006-08-01 at 09:22 +0200, Thomas G=FCnther wrote: > Hello, >=20 > =20 >=20 > my configuration exists of 2 db-nodes, 2 replication nodes and 1 > loadbalancer. >=20 > =20 >=20 > Is it able to replicate only some tables (not all) to a third db > node.=20 >=20 > Has someone experiences with cascaded reolication. >=20 > Can anyone post a sample conf for cascading? >=20 Slony supports cascading replicas. What you would do is create two sets, one set would only get replicated to the second DB, and the other one would get subscribed from the second DB to the 3rd DB. If you want more information or assistance, the Slony list is the place to ask. Brad.