X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 99A269DC98B for ; Wed, 1 Mar 2006 19:23:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30854-06 for ; Wed, 1 Mar 2006 19:23:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by postgresql.org (Postfix) with ESMTP id A7CDC9DC821 for ; Wed, 1 Mar 2006 19:23:12 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:40292 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1FEaf4-0004rH-KT for pgsql-sql@postgresql.org; Wed, 01 Mar 2006 18:23:14 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id CB6EE4051; Wed, 1 Mar 2006 18:23:13 -0500 (EST) Date: Wed, 1 Mar 2006 18:23:13 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Replication - state of the art? Message-ID: <20060301232313.GA5656@phlogiston.dyndns.org> References: <20060301133041.8EFFA19B797@smtp03l.fasthosts.co.uk> <4405DF32.4070307@obviously.com> <20060301182803.GK17356@phlogiston.dyndns.org> <4405F5C6.1040300@obviously.com> <20060301194918.GA5200@phlogiston.dyndns.org> <20060301221518.GW82012@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060301221518.GW82012@pervasive.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.081 required=5 tests=[AWL=0.081] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200603/36 X-Sequence-Number: 24382 On Wed, Mar 01, 2006 at 04:15:18PM -0600, Jim C. Nasby wrote: > You could also use WAL shipping and some PITR trickery to keep a 'warm > standby' database up to date. How far behind it falls is up to you, > since you'll be periodically syncing the current WAL file to the backup > machine. Do the sync once a minute, and at most you lose 60 seconds of > data. Right. But you have to write all of that, and write the failover scripts, and such like. And the OP suggested that there wasn't time budget for that. But it'd work. A -- Andrew Sullivan | ajs@crankycanuck.ca The whole tendency of modern prose is away from concreteness. --George Orwell