Hello Slony users.

Has anyone backed up and restored a PostgreSQL database that's being
replicated using Slony?

I created a backup like this on the master/origin:

sudo -u postgres pg_dump -Fc -f /tmp/mydatabase.bak  mydatabase

Then I tried to restore it like this on the master/origin:

sudo -u postgres pg_restore -Fc -d mydatabase -c /tmp/mydatabase.bak

But I got the following errors (because the -c option attempted to
clean the database):

pg_restore: NOTICE:  drop cascades to function xxid_snapshot_out(xxid_snapshot)
pg_restore: NOTICE:  drop cascades to function xxid_snapshot_in(cstring)
pg_restore: [archiver (db)] could not execute query: ERROR:  type
"xxid_snapshot" does not exist

What is the correct procedure for creating and restoring backups of
Slony-replicated databases?
Do the slon processes need to be shutdown prior to taking backups?
What about prior to restoration?



Thank you.



-Fiel Cabral