Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 29434B5DBE5 for ; Mon, 15 Aug 2011 19:29:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 81193-05 for ; Mon, 15 Aug 2011 22:29:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id C1EFDB5DBE1 for ; Mon, 15 Aug 2011 19:29:12 -0300 (ADT) Received: from [89.157.192.174] (helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1Qt5ef-0001Ii-7D; Tue, 16 Aug 2011 00:29:09 +0200 Received: by DimIMac.local (Postfix, from userid 501) id 95ECD26B704B; Tue, 16 Aug 2011 00:29:03 +0200 (CEST) From: Dimitri Fontaine To: Maria.L.Wilson-1@nasa.gov Cc: "pgsql-admin\@postgresql.org" Subject: Re: Postgresql 8.4 replication using Londiste Organization: 2ndQuadrant References: <4DEFD00C.8030600@nasa.gov> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Tue, 16 Aug 2011 00:29:03 +0200 In-Reply-To: <4DEFD00C.8030600@nasa.gov> (Maria L. Wilson's message of "Wed, 8 Jun 2011 15:39:56 -0400") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.18 tagged_above=-10 required=5 tests=BAYES_00=-1.9, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201108/136 X-Sequence-Number: 38123 "Maria L. Wilson" writes: > Interested in using Londiste to set up replication of only one column in a > particular database to another database on a remote Postgres server. I've > installed and configured londiste on the servers - that was no problem. I > just don't see anything in the docs that specify how to replicate only one > column - not the entire table. Anybody out there have any expertise in this > that can point me in the right direction? That's supported in skytools3, currently in release candidate status. Those are the arguments you can give to the add table command: londiste provider add table --trigger-arg ... -- Optinal arguments: -- SKIP - The actual operation should be skipped (BEFORE trigger) -- ignore=col1[,col2] - don't look at the specified arguments -- pkey=col1[,col2] - Set pkey fields for the table, autodetection will be skipped -- backup - Put urlencoded contents of old row to ev_extra2 -- colname=EXPR - Override field value with SQL expression. Can reference table -- columns. colname can be: ev_type, ev_data, ev_extra1 .. ev_extra4 -- when=EXPR - If EXPR returns false, don't insert event. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support