On 7/20/2011 3:50 AM, Juan Antonio de los Palotes Machado wrote:
> On Wed, Jul 20, 2011 at 12:11 AM, Daniel Kahn Gillmor
> <dkg at fifthhorseman.net>  wrote:
>>  On 07/18/2011 11:25 AM, Juan Antonio de los Palotes Machado wrote:
>>>      try to remove the slony schemas by hand and then recreating the
>>>  node. as long as your data is still in your master you should not lose
>>>  anything.
>>
>>  When you say "remove the schemas by hand", do you mean psql, or slonik
>>  commands?
>
>      psql

I have not seen Daniel mentioning any version numbers. In any case, 
please do NOT give this advice unconditional. Before version 2.0 
dropping the Slony-I schema by hand (DROP SCHEMA ... CASCADE) was a big 
foot gun that left people stranded with corrupted system catalogs.

>
>>  Ultimately (guided by stevenSn on #slony on irc.freenode.net), i used
>>  slonik commands to drop the nodes that weren't replicating properly, and
>>  then repeated the store node commands for those nodes.
>
>      aha, interesting. how?

Probably using slonik commands "drop node" and "uninstall node", then 
rebuilding them with "store node" and "subscribe set".


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin