Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8C9589FA4D4 for ; Thu, 5 Jul 2007 14:18:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25453-09 for ; Thu, 5 Jul 2007 14:18:21 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 471099FA181 for ; Thu, 5 Jul 2007 14:18:21 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l65HIA0c070931 for ; Thu, 5 Jul 2007 14:18:10 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l65H3rXu068094 for pgsql-admin@postgresql.org; Thu, 5 Jul 2007 14:03:53 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Help me find a suitable replication solution Date: Thu, 05 Jul 2007 12:44:13 -0400 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: <60lkdu3in6.fsf@dba2.int.libertyrms.com> References: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.20 (linux) Cancel-Lock: sha1:jfKOPdZ6RfswXp2Cq2YeHKQ6gLA= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/45 X-Sequence-Number: 26026 hongyuan1306@gmail.com ("Yuan HOng") writes: > It seems Slony-II would be quite promising, but I can't wait that > long. What is the best choice for me now? Worth noting: Slony-II would never have been suitable, as it would have required that all the "master" servers be in the same data centre. I don't think you have an easy answer here... -- select 'cbbrowne' || '@' || 'cbbrowne.com'; http://cbbrowne.com/info/internet.html (THASSERT (PLANNER RG)) -- Example of HACKER statement.