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