DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=i6mDT2p0O0ecXeh9g+E+OMfBxd/RuWkyf1DX3ay5uEhCnIZ1eJBcuZvHwZKfFETUTh
	PhRLxEWyyhpQSSh+NtT7dJyZmftHZKjj6wq+AqJ6c8AyBKywONCDpA/LvwHeCyWgyBWX
	GKYu98h+/MY7kwfEhJoZwb1DEI/yDRv9I9JEc=
MIME-Version: 1.0
In-Reply-To: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com>
References: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com>
Date: Sun, 7 Feb 2010 20:32:46 -0700
Message-ID: <dcc563d11002071932r136b9d3eyc004fd0452ef24c4@mail.gmail.com>
Subject: Re: Best Replication Tool
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Kiswono Prayogo <kiswono@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

On Sun, Feb 7, 2010 at 8:22 PM, Kiswono Prayogo <kiswono@gmail.com> wrote:
> 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?

Well, you're not telling us how much traffic you're looking at or how
powerful your servers will be.  Where I work we have two large master
servers (lots of SAS drives on power hardware RAID controllers with
battery backed cache) which are our master and slave-master, so to
speak, then we currently have two, but may have more, slaves synced
off of the slave-master machine.  We use slony.  It works well enough,
but there are some issues with large numbers of db objects (lots of
tables / indexes / schemas) that we've run into with it that are
making me pull some hair out, and I haven't had time to troubleshoot
them.

Overall though, it's a quite capable system, and once it's setup and
running it's fast and stable.

There's also londiste, bucardo, and a few others worth looking at.