Search Postgresql Archives

Re: Stripping out slony after / before / during pg_restore?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

--
  Richard Huxton


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux