On 11/20/2004 10:10 PM, Marc G. Fournier wrote:

> What is the usual procedure for adding another subscriber on, as far as 
> copying the schema over?   pg_dump the table on the master, edit out the 
> slony 'extras' and load that?  or is there a better/cleaner way

You can do a schema only dump (including the slony pollution) on the 
origin (master) and either edit it out or simply drop that slony schema 
after loading it into an empty database. That will give you the right 
starting position to do

     store node
     store path (multiple)
     store listen (many)
     subscribe set


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #