pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (15+ messages)  latest in thread

Message-ID: <20061005042417.87F0FC027@ogo.rapideye.de>
Permalink:  ../20061005042417.87F0FC027@ogo.rapideye.de/
Also on:    postgresql.org/message-id/20061005042417.87F0FC027@ogo.rapideye.de

 · 

reply

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