Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C64FE9F9FE1 for ; Thu, 7 Dec 2006 06:06:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 71087-05 for ; Thu, 7 Dec 2006 06:06:17 -0400 (AST) X-Greylist: delayed 00:30:14.409071 by SQLgrey-1.7.4 Received: from mail.instadia.net (mail.instadia.net [80.165.96.2]) by postgresql.org (Postfix) with ESMTP id 1126D9F938C for ; Thu, 7 Dec 2006 06:06:17 -0400 (AST) Received: from [10.0.0.14] (dev8.instadia.net [10.0.0.14]) by mail.instadia.net (Postfix) with ESMTP id A2FC1D55FA for ; Thu, 7 Dec 2006 10:36:00 +0100 (CET) Message-ID: <4577E080.4060705@instadia.net> Date: Thu, 07 Dec 2006 09:36:00 +0000 From: Morten Andersen User-Agent: Debian Thunderbird 1.0.2 (X11/20060926) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Recovery plan for DRDB setup - recovery tool Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200612/42 X-Sequence-Number: 23834 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