Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A63399FB207 for ; Thu, 5 Oct 2006 01:24:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11915-09 for ; Thu, 5 Oct 2006 01:24:20 -0300 (ADT) X-Greylist: delayed 17:00:37.089069 by SQLgrey- Received: from ogo.rapideye.de (ogo.rapideye.de [212.204.56.174]) by postgresql.org (Postfix) with ESMTP id 319ED9FB1B8 for ; Thu, 5 Oct 2006 01:24:20 -0300 (ADT) Received: by ogo.rapideye.de (Postfix, from userid 1000) id 87F0FC027; Thu, 5 Oct 2006 06:24:17 +0200 (CEST) organization: RapidEye AG cc: pgsql-admin@postgresql.org X-Mailer: OpenGroupware.org MIME-Version: 1.0 from: "Sebastian Reitenbach" Subject: Re: postgres in HA constellation reply-to: "Sebastian Reitenbach" content-type: text/plain; charset="us-ascii" date: Thu, 05 Oct 2006 04:24:17 -0000 content-transfer-encoding: 7bit Message-Id: <20061005042417.87F0FC027@ogo.rapideye.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/27 X-Sequence-Number: 23330 Hi, Bruno Wolff III wrote: > On Wed, Oct 04, 2006 at 11:23:45 -0000, > Sebastian Reitenbach 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