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

2008-10-13 Thread Stuart Bishop
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

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

2008-10-13 Thread Stuart Bishop
On Mon, Oct 13, 2008 at 5:05 PM, Stuart Bishop [EMAIL PROTECTED] wrote: So what was the final recommended process for building a stand alone database from a pg_dump of a replicated node? So if I'm reading this thread correctly, the alternative is 'DROP _sl CASCADE;', which doesn't do a full

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

2008-09-25 Thread Christopher Browne
Richard Huxton [EMAIL PROTECTED] 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