Re: [GENERAL] Stripping out slony after / before / during pg_restore?

Glyn Astill wrote:
> Hi people,
>
> I'm setting us up a separate staging / test server and I want to read
> in a pg_dump of our current origin stripping out all the slony stuff.
>
> I was thinking this could serve two purposes a) test out backups
> restore properly and b) provide us with us with the staging / test
> server
>
> What's the best way to remove all the slony bits?

Well, you can always just drop the slony schema (with a cascade) - that
should do it.

--
Richard Huxton

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general