Recovery plan for DRDB setup - recovery tool

From: Morten Andersen <moa-ml(at)instadia(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Recovery plan for DRDB setup - recovery tool
Date: 2006-12-07 09:36:00
Message-ID: 4577E080.4060705@instadia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2006-12-07 13:03:27 Re: Recovery plan for DRDB setup - recovery tool
Previous Message Devrim GUNDUZ 2006-12-06 19:36:02 Re: 8.2 install to fc5 fails rtld needed