Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DABF164FD15 for ; Thu, 11 Sep 2008 12:43:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68285-02-8 for ; Thu, 11 Sep 2008 12:43:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.226]) by postgresql.org (Postfix) with ESMTP id A6E3D6500EE for ; Thu, 11 Sep 2008 12:43:06 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so496603rvf.43 for ; Thu, 11 Sep 2008 08:43:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=Cw12lTeDLCGesD6Hu9k6GChe+M/lmYIkzC/VpLWRp9w=; b=YvqpZsSlV6oDSgkNa5/Bquy+NGNQYn6Dn2XC2Ub+tHRTgGBvAdq7Mx3KUH6YhkTH7b qcWFF+5OZ1gVKWginBHg2/hZrCZPFMJE5ZcqFbxLnadFh1AOMBPvUBNQvnvf/bDrGsKA BCrwvcNkmYk/TlpimbwTs3S1scO08fqURQBgs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=oA3fP1Kphu9Gcqj9ZBsP3uiNmZV/K8GB0Ig9zJYTVZQCobdhorEBDe3IQeLKkQB2k2 YXP3xIj9+HP0Ap2VOz9VCJsh12dwH+ZxsO4xgfEUdzoDeReAYAfa5MrbaJUKtFnH/FFE WdM7zplus9Nw+TXXZVIL6U/9Xb1G+rinTZVfw= Received: by 10.141.97.5 with SMTP id z5mr1850352rvl.226.1221147785365; Thu, 11 Sep 2008 08:43:05 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Thu, 11 Sep 2008 08:43:05 -0700 (PDT) Message-ID: Date: Thu, 11 Sep 2008 09:43:05 -0600 From: "Scott Marlowe" To: rexmabry@yahoo.com Subject: Re: replica of database Cc: "pgsql-admin@postgresql.org" In-Reply-To: <327914.769.qm@web35904.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <327914.769.qm@web35904.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200809/98 X-Sequence-Number: 30191 On Thu, Sep 11, 2008 at 7:42 AM, Rex Mabry wrote: > Version 8.3 has pg_standby. Does anyone know how well that works for > failover? pg_standby is part of the Point in time recovery suite, which can be used to create a cold (recovery on comand) or warm standby (continuous recovery) server ready to take over with a few commands. It's quite different from slony, in that there's not hot read-only standby, so there's no load balancing, however, it usually produces less load on the master db, so that's a plus. PITR is quite well tested and used in a lot of production environments. It has very different design objectives than slony or pgpool or pgbouncer, which all allow you to have multiple live servers at once.