Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Stripping out slony after / before / during pg_restore?
- 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
- Subject: Re: Stripping out slony after / before / during pg_restore?
- Date: Tue, 13 May 2008 13:34:18 +0100
- Message-id: <48298ACA(dot)1050002(at)archonet(dot)com>
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
- References:
- Stripping out slony after / before / during pg_restore?
- From: Glyn Astill
- Stripping out slony after / before / during pg_restore?
- Prev by Date: Re: Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service
- Next by Date: Re: pg_standby / WAL archive-restore through system restarts
- Previous by thread: Stripping out slony after / before / during pg_restore?
- Next by thread: Re: Stripping out slony after / before / during pg_restore?
- Indexes: