Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 496D89FB774 for ; Thu, 5 Jul 2007 15:47:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 63660-02-2 for ; Thu, 5 Jul 2007 15:47:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id E73C49FB6C7 for ; Thu, 5 Jul 2007 15:47:34 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1I6WMV-0006d9-Or for pgsql-admin@postgresql.org; Thu, 05 Jul 2007 14:47:31 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 336513FAF; Thu, 5 Jul 2007 14:47:26 -0400 (EDT) Date: Thu, 5 Jul 2007 14:47:26 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Help me find a suitable replication solution Message-ID: <20070705184726.GK17424@phlogiston.dyndns.org> References: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/52 X-Sequence-Number: 26033 On Tue, Jul 03, 2007 at 08:15:35AM +0800, Yuan HOng wrote: > sites shall update these tables, and the link is over a WAN, it seems > the most appropriate replication solution would be a multi-master, > asynchronous solution. Yes, that would be best. > be to use a separate table for order on web server and replicate it > back to inhouse server. But then I have two tables for order, which > will make the applicate much complicated. Yep. > Finding no suitable soluiton for my case, I am wondering whether I > have made a mistake in my database design. Havent' others experienced > similiar situation as I do? Or do I have some misunderstanding of the > capabilities of the existing solutions? Am I overlooking something? There simply isn't anything that implements this now. It's possible to bodge it up using Slony, as you point out, but that makes things more complicated. If you need this now, though, that's your only option AFAIK. A -- Andrew Sullivan | ajs@crankycanuck.ca Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris