Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Stripping out s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 15521 of 17437
Post > Topic >>

Stripping out slony after / before / during pg_restore?

by glynastill@[EMAIL PROTECTED] (Glyn Astill) May 13, 2008 at 12:12 PM

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
pr=
operly 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
n=
ot have to run the slon daemons.

Or should I just leave all the slony stuff in there... would it cause us
an=
y problems? There'd be no slons running and the next night it's all wiped
a=
nd 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

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 8 Posts in Topic:
Stripping out slony after / before / during pg_restore?
glynastill@[EMAIL PROTECT  2008-05-13 12:12:03 
Re: Stripping out slony after / before / during pg_restore?
dev@[EMAIL PROTECTED] (R  2008-05-13 13:34:18 
Re: Stripping out slony after / before / during pg_restore?
singh.gurjeet@[EMAIL PROT  2008-05-13 18:07:41 
Re: Stripping out slony after / before / during pg_restore?
vivek@[EMAIL PROTECTED]   2008-05-13 10:50:40 
multicolumn index join
since@[EMAIL PROTECTED]   2008-05-13 11:27:54 
Re: multicolumn index join
dalroi@[EMAIL PROTECTED]   2008-05-15 08:29:48 
Re: multicolumn index join
scott.marlowe@[EMAIL PROT  2008-05-13 10:50:51 
Re: [Slony1-general] Re: Stripping out slony after / before / du
cbbrowne@[EMAIL PROTECTED  2008-09-25 13:05:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 11:47:42 CST 2008.