From: Morten Andersen <moa-ml@instadia.net>
To: pgsql-admin@postgresql.org
Subject: Re: Recovery plan for DRDB setup - recovery tool
Date: Fri, 08 Dec 2006 09:42:27 +0000
Message-ID: <45793383.2090505@instadia.net> (raw)
In-Reply-To: <200612071403.27722.peter_e@gmx.net>
References: <4577E080.4060705@instadia.net>
<200612071403.27722.peter_e@gmx.net>
Hi Peter,
Peter Eisentraut wrote:
> Morten Andersen wrote:
>
>>So are there any Postgresql tools for analyzing and repairing the
>>"offline" database files (like e.g. the MySQL 'myisamchk'-tool).
>
>
> No.
>
>
>>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.
>
>
> If you don't trust PostgreSQL, why would you trust its offline recovery
> tools?
:-) - sorry, I probably misphrased the question a little. It is not
really Postgresql I don't trust. It is more the combination of HW on two
machines, network and DRDB. And it is not really an issue about not
trusting any of the components involved, but about knowing what to do if
we ever find us self with a group of erroneous DB files.
But since you answered that no offline tools exist, and due to phrases
like this:
".. Since the postmaster can now clean up by itself, it is unlikely that
ipcclean will be improved upon in the future." (from the notes section
in the 'ipcclean' utility description:
http://www.postgresql.org/docs/8.1/static/app-ipcclean.html)
I assume that Postgresql is partly "self-repairing", and will handle any
required cleaning when a DRDB slave starts after a DRDB master failure.
Best Regards
Morten Andersen,
Instadia, Denmark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: moa-ml@instadia.net
Subject: Re: Recovery plan for DRDB setup - recovery tool
In-Reply-To: <45793383.2090505@instadia.net>
References: <4577E080.4060705@instadia.net> <200612071403.27722.peter_e@gmx.net> <45793383.2090505@instadia.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox