Glyn Astill <glynastill at yahoo.co.uk> writes:
> AFAIK you cannot dump out, then restore a schema with slony in place.
>
> Slony uses object OIDs (as you've seen in alterTableRestore()) and even with the -o flag you cannot dump them, you can only dump the OIDs for row data, thus when you reload all your data the slony schema is junk.
>
> The only way to do it is to drop cascade the slony schema and setup the slony cluster again by starting from scratch or adding it as a new node to an existing cluster.
>
> Put me straight if I'm wrong here people.

There is a Slonik command intended to do this sort of repair...
  <http://linuxfinances.info/info/stmtrepairconfig.html>
-- 
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://cbbrowne.com/info/lsf.html
Rules  of the  Evil Overlord  #145. "My  dungeon cell  decor  will not
feature exposed pipes.  While they add to the  gloomy atmosphere, they
are good  conductors of vibrations and  a lot of  prisoners know Morse
code." <http://www.eviloverlord.com/>