Re: Postgresql 8.4 replication using Londiste

"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