cbbrowne at ca.afilias.info cbbrowne
Thu Aug 4 18:28:57 PDT 2005
> How can I dump the master database with the replication schema exclution.
>
> I tried the pg_dump -n public or pg_dump --schema=public but in the dumped
> data there is still a lot of information about the replication set.
>
> What I want to do is to make a copy of the database but without the slony
> replication set.

You can get Very Nearly Close using some combination of
test/slony1_extract_schema.sh (which just dumps the schema) and
tools/slony1_dump.sh (which dumps just data, along with a little bit of
"special stuff").

It would probably be handy to have some script to combine the
functionality, but there isn't one.



More information about the Slony1-general mailing list