X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7F54ADBA92 for ; Fri, 18 Nov 2005 11:06:10 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29919-06 for ; Fri, 18 Nov 2005 15:06:13 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp104.rog.mail.re2.yahoo.com (smtp104.rog.mail.re2.yahoo.com [206.190.36.82]) by svr1.postgresql.org (Postfix) with SMTP id 73E70DBAA4 for ; Fri, 18 Nov 2005 11:06:07 -0400 (AST) Received: (qmail 23548 invoked from network); 18 Nov 2005 15:06:07 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp104.rog.mail.re2.yahoo.com with SMTP; 18 Nov 2005 15:06:07 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 04CE340E6; Fri, 18 Nov 2005 10:06:06 -0500 (EST) Date: Fri, 18 Nov 2005 10:06:05 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: idea for a geographically distributed database: how best to implement? Message-ID: <20051118150605.GA28967@phlogiston.dyndns.org> References: <20051117200220.8F0BE111E6E@yugib.highrise.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/148 X-Sequence-Number: 23399 On Fri, Nov 18, 2005 at 09:09:24AM -0000, Andy Ballingall wrote: > That's very interesting! I've not used slony yet, so I'll setup some tests > and try exactly this mechanism. If you do this with Slony, and have any success, I know that the folks on the Slony list would dearly like to hear about it (especially if you can provide details of how you did it). If you get this working in a production system, I can think of more than one conference that would _also_ like a paper on it. A -- Andrew Sullivan | ajs@crankycanuck.ca A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton