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
------------------------------------------------------------------