Stripping out slony after / before / during pg_restore?

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: slony1-general(at)lists(dot)slony(dot)info
Cc: pgsql-general(at)postgresql(dot)org
Subject: Stripping out slony after / before / during pg_restore?
Date: 2008-05-13 12:12:03
Message-ID: 349621.46525.qm@web25806.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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?

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 the next 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kev 2008-05-13 12:15:03 Re: Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service
Previous Message Merlin Moncure 2008-05-13 12:09:00 Re: Server not listening