From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Maria.L.Wilson-1@nasa.gov
Cc: pgsql-admin\@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgresql 8.4 replication using Londiste
Date: Tue, 16 Aug 2011 00:29:03 +0200
Message-ID: <m2obzqs40g.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <4DEFD00C.8030600@nasa.gov>
References: <4DEFD00C.8030600@nasa.gov>
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> 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 <ini> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dimitri@2ndQuadrant.fr, Maria.L.Wilson-1@nasa.gov
Subject: Re: Postgresql 8.4 replication using Londiste
In-Reply-To: <m2obzqs40g.fsf@2ndQuadrant.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox