Stripping out slony after / before / during pg_restore? - Mailing list pgsql-general

From Glyn Astill
Subject Stripping out slony after / before / during pg_restore?
Date
Msg-id 349621.46525.qm@web25806.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Stripping out slony after / before / during pg_restore?  (Richard Huxton <dev@archonet.com>)
Re: Stripping out slony after / before / during pg_restore?  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-general
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
allthe 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?

I was thinking read in the dump, then use uninstall node - but I'd rather not have to run the slon daemons.

Or should I just leave all the slony stuff in there... would it cause us any problems? There'd be no slons running and
thenext night it's all wiped and restored again... 

Anyone got any ideas? Anyone got something similar already?

Cheers
Glyn


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Server not listening
Next
From: Richard Huxton
Date:
Subject: Re: Stripping out slony after / before / during pg_restore?