"Maria L. Wilson" <[email protected]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
