From: Sebastian Reitenbach <itlistuser@rapideye.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres in HA constellation
Date: Thu, 05 Oct 2006 04:24:17 -0000
Message-ID: <20061005042417.87F0FC027@ogo.rapideye.de> (raw)
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.
> >
> > are there any other possibilities that might work that I am not aware of?
> > anybody has experiences with postgres in a HA environment with shared
storage?
>
> You can also use servers with redundant hardware (hotplug CPUs and the like)
> to make failure less likely. If you get the hardware failure rates down to
> that of your storage system, that might be good enough for your purposes.
>
> If you have multiple data centers to protect against disaster, then you
might
> look at SLONY which you can use to replicate to a slave system. However, I
> think it is possible for the master to report a transaction as commited
> before it is shipped off to the slave, so that if the master fails you might
> lose some transactions when switching to the slave. But double check with
> the SLONY documentation on this.
I just have one data center, no remote far away replication is needed.
thank you all for your answers
kind regards
Sebastian
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: itlistuser@rapideye.de
Subject: Re: postgres in HA constellation
In-Reply-To: <20061005042417.87F0FC027@ogo.rapideye.de>
References: <20061005042417.87F0FC027@ogo.rapideye.de>
* 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