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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------