Alan Hodgson ahodgson
Fri Mar 4 20:35:53 PST 2005
Is there a way to backup and restore a cluster member without having
to redo the replication setup?  I have 5 nodes to upgrade to 8.0.1.
The slave nodes only replicate a subset of the tables on the master.  
Re-replicating out the slave nodes and setting up the paths and listeners,
especially one at a time, is a major pain.

I know enough to kill the slons, make the db unavailable to other processes,
and back it up and restore it without anything else touching it.  I know
to update the table OID's in sl_table.  However, I seem to be missing where
it sticks the old trigger info.  Is this even possible?

-- 
Politicians only fear one thing: peasants with guns



More information about the Slony1-general mailing list