Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DDC0C62DBD5 for ; Tue, 9 Feb 2010 06:53:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 29949-08 for ; Tue, 9 Feb 2010 10:53:11 +0000 (UTC) Received: from mx2.hub.org (mx2.hub.org [200.46.204.254]) by mail.postgresql.org (Postfix) with ESMTP id 6462263260C for ; Tue, 9 Feb 2010 06:52:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mx2.hub.org (Postfix) with ESMTP id A60261E82AD9 for ; Tue, 9 Feb 2010 06:52:45 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 4471593B97; Tue, 9 Feb 2010 11:42:59 +0100 (CET) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id AgIetcl8rz37; Tue, 9 Feb 2010 11:42:59 +0100 (CET) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 8761693B9A; Tue, 9 Feb 2010 11:42:56 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail1.hi-media-techno.com (Postfix) with ESMTP id 659EC1C197; Tue, 9 Feb 2010 11:42:56 +0100 (CET) X-Virus-Scanned: amavisd-new at mail1.hi-media-techno.com Received: from mail1.hi-media-techno.com ([127.0.0.1]) by localhost (mail1.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id REhccLm3ZipT; Tue, 9 Feb 2010 11:42:56 +0100 (CET) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id F10C51431F; Tue, 9 Feb 2010 11:42:55 +0100 (CET) Received: by dim (Postfix, from userid 1000) id 6D04E13F43; Tue, 9 Feb 2010 11:39:08 +0100 (CET) From: Dimitri Fontaine To: Kiswono Prayogo Cc: pgsql-admin@postgresql.org Subject: Re: Best Replication Tool Organization: Hi-Media References: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com> Date: Tue, 09 Feb 2010 11:39:08 +0100 In-Reply-To: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com> (Kiswono Prayogo's message of "Mon, 8 Feb 2010 10:22:12 +0700") Message-ID: <87k4umg0c3.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.611 tagged_above=-10 required=5 tests=AWL=-0.773, BAYES_00=-2.599, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201002/71 X-Sequence-Number: 33674 Kiswono Prayogo writes: > Hi, i'm really new to postgresql replication, was there any > replication tool for postgresql that can do real-time replication from > 1 database to ~3-10 database (on the other machines) with little > overhead for load balancing purpose? My prefered asynchronous replication solution for PostgreSQL is Londiste from Skytools, don't miss its tutorial: http://wiki.postgresql.org/wiki/Londiste_Tutorial Regards, -- dim