A month ago I spoke about first steps in Yandex.Mail with PostgreSQL and particularly about our tools to provide fault tolerance. One of them is pgcheck - tool for monitoring backend databases from PL/Proxy hosts and changing
plproxy.get_cluster_partitions function output to for controlling load on databases.
More info could be found on github as pgcheck is open source now. Enjoy.