What is the recommended way to capture a "snapshot" of an entire slony
cluster at a point in time, such that it is possible to restore the
cluster to that point in time (without having to drop/resubscribe nodes)?

We can stop activity on the cluster while taking the snapshot, but
ideally would like to avoid having to dump every node independently. We
will have both slony-managed and non-slony-managed tables (although the
non-slony-managed tables should also be in sync across the nodes).

The ultimate goal it to provide a way to reset the cluster to a known
state in order to facilitate testing.

Pointers, ideas, URLs appreciated.

Thanks,

Joe




-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support