Thanks it worked well with the internal Slony commands. 

ATM I am replicating 140 PG tables, some of them exceed 8-9 million records, size in total is 35-36 GB of data.

Are there any performance issues with Slony-I replicating these sort of volumes? Writes occur quite often as there are at least 100 active users around the clock.

Slony processes on both systems do not seem to generate any significant load.

-----Original Message-----
From: Christopher Browne [mailto:cbbrowne at ca.afilias.info] 
Sent: 14 April 2009 01:31
To: Johnny Edge
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] add table to existing set/namespace

"Johnny Edge" <jedge at visafirst.com> writes:
> So far this was suggested.
>
> 1. Create a "dummy" set (id=999)
> 2. Add the new table to set 999
> 3. Subscribe to the new set 999
> 4. Merge set 999 with set 1
>
>  
>
> Can you provide an example? 

There are examples of these sorts of things in the manual pages.

http://slony.info/documentation/stmtcreateset.html
http://slony.info/documentation/stmtsetaddtable.html
http://slony.info/documentation/stmtsubscribeset.html
http://slony.info/documentation/stmtmergeset.html

> Can the whole procedure be 'simplified' to altering the existing 
> sequence with SQL queries, i.e. add new record for the new table?

Conceivably, but that's likely to be more fragile than using the Slonik commands that are designed to do the job.

> Do I have to create a new cluster that is to be merged with the 
> existing one?

No, if you created another cluster, it would be impossible to merge that with the existing cluster.

http://slony.info/documentation/cluster.html
--
output = ("cbbrowne" "@" "ca.afilias.info") <http://dba2.int.libertyrms.com/> Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock phasers on the Heffalump, Piglet, meet me in transporter room three"