Re: Stripping out slony after / before / during pg_restore?

Thanks guys, that's exactly what I wanted.

----- Original Message ----
> From: Richard Huxton <dev(at)archonet(dot)com>
> To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
> Cc: slony1-general(at)lists(dot)slony(dot)info; pgsql-general(at)postgresql(dot)org
> Sent: Tuesday, 13 May, 2008 1:34:18 PM
> Subject: 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 from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html