Hello, You should ask directly to the slony1 mailing list. sjarosz@xxxxxxxxx a écrit : > (...) The Slony version I'm using is 1.1.2. The current version of Slony1 is slony1-1.2.6. > Take a scenario that > you want to check the state of the system without prior knowledge of > the node setup, how would you determine which machine is the prime and > which one is the slave? > Without any knowledge of replication ? That will be difficult. You should connect to one of the DB and have a look at slony schema tables (sl_status and sl_listen for instance)... You may also have a look at that page : http://linuxfinances.info/info/monitoring.html > Also I'm having issues with the slonik script (below) that is supposed > to handle the failover to the slave in case of master failure. For > some reason it hangs and I was wondering if there are known issues with > it. As written in documentation "Slony-I does not provide any automatic detection for failed systems. " First of all, you may want to upgrade to the latest stable slony1 version. Cheers, SAS