Slony1 PostgreSQL Replication - pg_dump with replication set exclution

Author

pg_dump with replication set exclution

Andy

2005-08-04, 1:27 pm

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.

Best regards,
Andy.

cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org

2005-08-04, 1:27 pm

> How can I dump the master database with the replication schema exclutio=
n.
>
> I tried the pg_dump -n public or pg_dump --schema=3Dpublic but in the d=
umped

> 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 slo=
ny
> replication set.

You can get Very Nearly Close using some combination of
test/ slony1_extract_schem
a.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.

Sponsored Links