Thanks guys, that's exactly what I wanted.
----- Original Message ----
> From: Richard Huxton <dev@[EMAIL PROTECTED]
>
> To: Glyn Astill <glynastill@[EMAIL PROTECTED]
>
> Cc: slony1-general@[EMAIL PROTECTED]
pgsql-general@[EMAIL PROTECTED]
> Sent: Tuesday, 13 May, 2008 1:34:18 PM
> Subject: Re: [GENERAL] Stripping out slony after / before / during
pg_res=
tore?
>=20
> Glyn Astill wrote:
> > Hi people,
> >=20
> > 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.
> >=20
> > 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
> >=20
> > What's the best way to remove all the slony bits?
>=20
> Well, you can always just drop the slony schema (with a cascade) - that=
=20
> should do it.
>=20
> --
> Richard Huxton
__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
