Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8C8A79FB8DD for ; Wed, 30 May 2007 19:13:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 41458-01 for ; Wed, 30 May 2007 19:13:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 5153E9FB89C for ; Wed, 30 May 2007 19:13:25 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id p76so3857665pyb for ; Wed, 30 May 2007 15:13:24 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=dhUteCjkvkeupz30vGKeIq7UUwUgFyx71gcnO6PPVIJLCvV5iyZ/zX95T6haGMBwY9fgvcJOnLMW6oqtZ8Pn5+rPPH62zLcxsFgmjGCdMwmTHBAbFQyhRTTHB0DkGAX/oPQX/Fk0mJ4XjEAtoNKu22RLXqsjmV79FLUh5+xRYgo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=EB8JLNv5rHCOI929ORrYQywfND5SI5yVi6ZGre0C6XX9ztdiVVUQsb5W6R0oa1IaB1ksJzAxZBIs+ew03Wr2SYCWcbgEKRXERSYcShDUs/R6bAisT/Uduz8uunFhQ3Axk26bx4eh5IaYE6S+vZwbkTNeN2SQZpS6ErYE2YpQE/Q= Received: by 10.65.150.18 with SMTP id c18mr16346446qbo.1180563203786; Wed, 30 May 2007 15:13:23 -0700 (PDT) Received: from ?192.168.3.170? ( [68.79.189.145]) by mx.google.com with ESMTP id e13sm14648036qbe.2007.05.30.15.13.22; Wed, 30 May 2007 15:13:23 -0700 (PDT) Subject: Re: High Avaliable in the PostgreSQL. From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: Andrew Sullivan Cc: pgsql-admin@postgresql.org In-Reply-To: <20070530211833.GA17639@phlogiston.dyndns.org> References: <20070530164208.2657ee91@localhost> <20070530211833.GA17639@phlogiston.dyndns.org> Content-Type: text/plain Date: Wed, 30 May 2007 18:12:02 -0400 Message-Id: <1180563122.4265.2.camel@aleph.whitemice.org> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/324 X-Sequence-Number: 25644 On Wed, 2007-05-30 at 17:18 -0400, Andrew Sullivan wrote: > On Wed, May 30, 2007 at 04:42:08PM -0300, Fernando Ike de Oliveira wrote: > > was 99,7% but considering the current necessities, change percentual > > to 99,99%. I think in solution probability pgpool-2 or Heartbeat + > > GFS. The PostgreSQL servers will be in different physical places. > I would be very interested to see a set-up that can actually > guarantee 99.99% uptime across a wide area link. Sure it can be done. Get two SANs that support replication, redundant high-speed WAN links, high end servers, large UPSs, and generators. It is just extremely expensive. :) -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org