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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
Cc: slony1-general(at)lists(dot)slony(dot)info, pgsql-general(at)postgresql(dot)org
Subject: Re: Stripping out slony after / before / during pg_restore?
Date: 2008-05-13 12:34:18
Message-ID: 48298ACA.1050002@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2008-05-13 12:37:26 Re: pg_standby / WAL archive-restore through system restarts
Previous Message Lionel 2008-05-13 12:26:46 Re: Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service