From: Brad Nicholson <bnichols@ca.afilias.info>
To: Sebastian Reitenbach <itlistuser@rapideye.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres in HA constellation
Date: Thu, 05 Oct 2006 14:57:02 -0400
Message-ID: <1160074622.15773.88.camel@dba5.int.libertyrms.com> (raw)
In-Reply-To: <20061005042417.87F0FC027@ogo.rapideye.de>
References: <20061005042417.87F0FC027@ogo.rapideye.de>
On Thu, 2006-10-05 at 04:24 +0000, Sebastian Reitenbach wrote:
> Hi,
>
> Bruno Wolff III <bruno@wolff.to> wrote:
> > On Wed, Oct 04, 2006 at 11:23:45 -0000,
> > Sebastian Reitenbach <itlistuser@rapideye.de> wrote:
> > >
> > > something I thought that might work:
> > > is there sth. that will repair an inconsisten postgresql datastore? e.g.
> the
> > > master database died, the slave will mount the storage, then repair it in
> a
> > > reasonable time, and then start to work.
> >
> > You can just start the slave server and it will recover using th WAL files
> > and should do so in a short time. However, you MUST be certain that the
> > master is no longer running when the slave starts or your database WILL BE
> > TRASHED.
> that sounds great, that I can just start the slave, and it will repair
> whatever broke. I am aware of that I have to make sure that the master is
> really dead.
Be absolutely sure that you test, test, test this. And then test it
some more. There are all sorts of nasty surprises that can happen in an
HA config that can leave you with a corrupt database. As mentioned, two
postmasters writing on the same directory is certainly one.
But you have to watch for problems in the HA config can as well.
What happens if the load on the master shoots up to the point where it
can't release the disk resources in time? Will the other box try and
take over an scribble on your file system?
What happens when you pull the plug on the master while under load
(either physically, or virtually with a halt -q)?
How does the HA solution play with your file system of choice?
Trust me, you want to know the answers to all of these questions and
more before you even consider turning an HA solution on in your
production environment. Don't just rely on the marketing material and
what sales drones tell you. If not, make sure you have good backups.
Brad.
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: bnichols@ca.afilias.info, itlistuser@rapideye.de
Subject: Re: postgres in HA constellation
In-Reply-To: <1160074622.15773.88.camel@dba5.int.libertyrms.com>
References: <20061005042417.87F0FC027@ogo.rapideye.de> <1160074622.15773.88.camel@dba5.int.libertyrms.com>
* 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