On Mon, Oct 13, 2008 at 6:10 PM, "Stéphane A. Schildknecht"
> What you can do is call the uninstallnode() procedure.
>
> It is located in the replication schema.
>
> You can call it like that :
> select _replication.uninstallnode();
>
> You should recover all tables in their normal state.
> Be sure your dump are done on master. Otherwise you will certainly lose
> information.

This appears to fail on a freshly restored dump because the oids are
different. The REPAIR CONFIG step seems necessary to get UNINSTALL
NODE to work.

(I'm using Slony 1.2.13 with PG 8.3 if that matters)

-- 
Stuart Bishop <stuart at stuartbishop.net>
http://www.stuartbishop.net/