Thursday, September 25, 2008

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

Richard Huxton <> writes:
> 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.

Not quite. There are two things that *doesn't* hit:

a) If there were any tables where a Slony-I key column got added,
DROP SCHEMA CASCADE doesn't trim that column out, which can
cause some minor heartburn. If you don't use TABLE ADD KEY,
then this isn't an issue.

b) In versions of Slony-I before 2.0, stripping out the schema on a
subscriber will leave triggers in a hidden state.

You want to look into UNINSTALL NODE, which does the full cleanup.
(format nil "~S@~S" "cbbrowne" "")
REALITY is a crutch for people who can't face ITS.

Sent via pgsql-general mailing list (
To make changes to your subscription:

No comments: