On Mar 7, 2005, at 12:01 PM, Chris Newland wrote:

> I'd like to ask what the Slony experts think is the best way to protect
> against a catastrophic loss of origin and all subscriber nodes if they
> are located in a single data centre and some physical disaster destroys
> the entire cluster.
>

The restore is not so hard if you know your schema pretty well.  Use 
pg_restore's "-l" option to get a list of the contents of the dump, 
edit that file to remove/comment out stuff you don't want, then restore 
using that edited index with pg_restore's "-L" option.  If you comment 
out all the slony-related stuff, you have a pristine copy of your data.