Re: Replication with slony-I

On 29/10/2008 12:55, Abdul Rahman wrote:

>   11.  Got SUCCESS up to this point. Now I think this is *pgbench *which
>       is responsible for replicating tables.

No - it's Slony which is responsible for the replication. pgbench is
just executing lots of SQL commands - SELECTs, UPDATEs, INSERTs, etc -
while Slony is replicating the changes from one set to the other.

> Now my question is that how to include the tables which are already
> present in an existing database

Just add more SET ADD TABLE commands to your slonik script. Use the
existing lines as a model, so you'll get something like:

  set add table (set id=1, origin=1, id=4, fully qualified name =
    'public.new_table', comment='Another table');


Make sure that the id is different for each table.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------