Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 47DD7133655C for ; Wed, 9 Feb 2011 03:19:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 07198-03 for ; Wed, 9 Feb 2011 07:19:35 +0000 (UTC) X-Greylist: delayed 00:07:59.982203 by SQLgrey-1.7.6 Received: from delta01.pnet.xcon.it (delta01.pnet.xcon.it [62.48.53.16]) by mail.postgresql.org (Postfix) with ESMTP id A06DA133616B for ; Wed, 9 Feb 2011 03:19:34 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by delta01.pnet.xcon.it (Postfix) with ESMTP id C322A180D967; Wed, 9 Feb 2011 08:11:32 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at delta01.pnet.xcon.it Received: from delta01.pnet.xcon.it ([127.0.0.1]) by localhost (delta01.pnet.xcon.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 5jkOCkz4DMyf; Wed, 9 Feb 2011 08:11:30 +0100 (CET) Received: from macbook-di-gabriele-bartolini.local (host15-194-dynamic.17-79-r.retail.telecomitalia.it [79.17.194.15]) (Authenticated sender: gabriele.bartolini@devise.it) by delta01.pnet.xcon.it (Postfix) with ESMTPSA id DF731180D963; Wed, 9 Feb 2011 08:11:29 +0100 (CET) Message-ID: <4D523E22.5000106@2ndQuadrant.it> Date: Wed, 09 Feb 2011 08:11:30 +0100 From: Gabriele Bartolini User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; it; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7 MIME-Version: 1.0 To: "Rangi, Jai" CC: pgsql-admin@postgresql.org Subject: Re: Postgres Replication Options References: <11F808DFED68574E8357241F5B39CAF5B96A24@mail-001.corp.automotive.com> In-Reply-To: <11F808DFED68574E8357241F5B39CAF5B96A24@mail-001.corp.automotive.com> Content-Type: multipart/alternative; boundary="------------080604090100050807070905" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.72 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 201102/50 X-Sequence-Number: 36689 This is a multi-part message in MIME format. --------------080604090100050807070905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, Il 09/02/11 01:34, Rangi, Jai ha scritto: > > Hello, > > I am looking for a replication solution for PG 9.x. Idea is to have > one master replication server and multiple (around 20) slave servers > read only. I see PG 9 has inbuilt Streaming replication. Is this the > best replication solution. How about slony? Which option will keep the > slave nodes in closest sync to master and which is more stable. > With PostgreSQL 9.0 in terms of builtin replication you can take advantage of Hot Standby based on either WAL shipping or on Streaming Replication.I would personally stick with builtin solutions if you plan to have full replicas of your databases, even in terms of maintenance and upgrades later on (in the long term). Some tools, including replication manager (repmgr) are coming out in order to manage HA clusters (for more info: http://blog.2ndquadrant.com/en/2011/01/easier-postgresql-90-clusters.html). Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it --------------080604090100050807070905 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi,

Il 09/02/11 01:34, Rangi, Jai ha scritto:

Hello,

I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How about slony? Which option will keep the slave nodes in closest sync to master and which is more stable. 

With PostgreSQL 9.0 in terms of builtin replication you can take advantage of Hot Standby based on either WAL shipping or on Streaming Replication. I would personally stick with builtin solutions if you plan to have full replicas of your databases, even in terms of maintenance and upgrades later on (in the long term). Some tools, including replication manager (repmgr) are coming out in order to manage HA clusters (for more info: http://blog.2ndquadrant.com/en/2011/01/easier-postgresql-90-clusters.html).

Cheers,
Gabriele
 
-- 
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it
--------------080604090100050807070905--