Hi all,

I read in documentation that dumping a slave is a really bad option as
slony1 modifies the catalog systems.

Knowing that, I guess backups have to be done on the master.  But, what
would be the risks to dump database on the slave without dumping the
slony replication schema?

Is it indeed possible to dump the database without including the
replication schema (neither on slave or master)? Would that give me a
fully usable dump?

By the way, I tried the knewly introduce feature in pg_dump, but I got a
really strange error :

pg_dump -U postgres MYDB -N "_MYDB" gives me a dump including that schema.

I then tried pg_dump -U postgres MYDB -n "_MYDB" and then got "pg_dump:
No matching schemas were found"

Dumping the only public schema works. But, by doing so, I miss some
other schema I really need.

Maybe I should ask on pgsql-general ML, but before that, I'd really like
to know if that way of processing is a good one.

Thanks by advance.

St?phane Schildknecht