Re: Postgresql 8.4 replication using Londiste

"Maria L. Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)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