<div dir="ltr">Slony version 2.0.3<br><br>I have a 2 node Slony cluster and I wish to cleanup everything (manually) if it is detected that one of the nodes has failed.<br><br>So, is just stopping the slon daemons and then executing 'uninstall node' for the remaining node enough to clean up everything?<br>
<br>$ ./slon_kill<br><br>$ ( ./slonik_print_preamble && echo 'uninstall node ( id = 2 ); ' ) | slonik<br><br>I looked at slonik.c;<span>slonik_uninstall_node() and </span><span>_cluster_name.uninstallNode() plpgsql function, all I could notice is that </span><span>slonik_uninstall_node() calls the plpgsql function and then issues 'drop schema _cluster_name cascade;'. The plpgsql function just issues a 'lock table _cluster_name.sl_config_lock'.<br>
<br>So I don't see a problem in performing the above 2 commands to clean up and then configure replication setup from scratch.<br><br>Any objections?<br><br>Regards,</span><br>-- <br>gurjeet.singh<br>@ EnterpriseDB - The Enterprise Postgres Company<br>
<a href="http://www.EnterpriseDB.com">http://www.EnterpriseDB.com</a><br><br>singh.gurjeet@{ gmail | yahoo }.com<br>Twitter/Skype: singh_gurjeet<br><br>Mail sent from my BlackLaptop device<br>
</div>