Hello, We are analyzing a master-slave setup of Postgresql 8.1 using DRDB (v.0.7, type 'C'), and judging from the mailing list, this setup is succesfully in production at several places. Our initial tests also shows that the failovers are problem free. But we would like to have a plan for how to handle the case where a failover fails. So are there any Postgresql tools for analyzing and repairing the "offline" database files (like e.g. the MySQL 'myisamchk'-tool). Or are there only "online" tools like 'vacuumdb --full --analyze'. So, how do other DRDB Postgresql sites handles failovers. Do you do anything pro-active on the slave before starting Postgresql, or do you trust DRDB and Postgresql completely. Best regards, and thanks for any input on both the usage of DRDB as well as on usage of recovery tools. Morten Andersen and Peter Bagger-Hansen, Instadia, Denmark
