Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id A06D91337B99
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 10 Feb 2011 09:56:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 02465-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 10 Feb 2011 13:56:09 +0000 (UTC)
X-Greylist: from auto-whitelisted 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 1904F1337B8D
	for <pgsql-admin@postgresql.org>; Thu, 10 Feb 2011 09:56:08 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by delta01.pnet.xcon.it (Postfix) with ESMTP id D8EC91803F40;
	Thu, 10 Feb 2011 14:56:07 +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 9pzVcS9QdHS5; Thu, 10 Feb 2011 14:56:05 +0100 (CET)
Received: from macbook-di-gabriele-bartolini.local
	(host114-123-dynamic.35-79-r.retail.telecomitalia.it [79.35.123.114])
	(Authenticated sender: gabriele.bartolini@devise.it)
	by delta01.pnet.xcon.it (Postfix) with ESMTPSA id E4A30180D972;
	Thu, 10 Feb 2011 14:56:04 +0100 (CET)
Message-ID: <4D53EE75.9070007@2ndQuadrant.it>
Date: Thu, 10 Feb 2011 14:56:05 +0100
From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
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: CS DBA <cs_dba@consistentstate.com>
CC: "Rangi, Jai" <jrangi@automotive.com>, pgsql-admin@postgresql.org
Subject: Re: Postgres Replication Options
References: 
 <11F808DFED68574E8357241F5B39CAF5B96A24@mail-001.corp.automotive.com>
	<4D523E22.5000106@2ndQuadrant.it>
	<4D52C684.1070808@consistentstate.com>
In-Reply-To: <4D52C684.1070808@consistentstate.com>
Content-Type: multipart/alternative;
	boundary="------------030902020905080009000409"
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/68
X-Sequence-Number: 36707

This is a multi-part message in MIME format.
--------------030902020905080009000409
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Il 09/02/11 17:53, CS DBA ha scritto:
> One of the main considerations per Hot Standby vs SLONY is replication 
> scope. With Hot Standby you get everything that occurs in the cluster, 
> across all databases. 
Yep, I agree with you Kevin regarding the replication scope. I assumed 
that Jai was looking for a full replica of the server.
> database.  So, IMHO I'd go with Hot Standby if I wanted to replicate 
> the full cluster and SLONY if I wanted to "slice & dice" tables and 
> target slaves (i.e. replicate all tables for a single db to slave 1, 
> only 50 tables to slave 2, etc...)
If you are looking for table level replication, I suggest also too look 
at Londiste and Skytools.

Ciao,
Gabriele

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


--------------030902020905080009000409
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
    <title></title>
  </head>
  <body text="#000000" bgcolor="#ffffff">
    Hi,<br>
    <br>
    Il 09/02/11 17:53, CS DBA ha scritto:
    <blockquote cite="mid:4D52C684.1070808@consistentstate.com"
      type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      One of the main considerations per Hot Standby vs SLONY is
      replication scope. With Hot Standby you get everything that occurs
      in the cluster, across all databases. </blockquote>
    Yep, I agree with you Kevin regarding the replication scope. I
    assumed that Jai was looking for a full replica of the server.
    <blockquote cite="mid:4D52C684.1070808@consistentstate.com"
      type="cite">database.&nbsp; So, IMHO I'd go with Hot Standby if I
      wanted to replicate the full cluster and SLONY if I wanted to
      "slice &amp; dice" tables and target slaves (i.e. replicate all
      tables for a single db to slave 1, only 50 tables to slave 2,
      etc...)<br>
    </blockquote>
    If you are looking for table level replication, I suggest also too
    look at Londiste and Skytools.<br>
    <br>
    Ciao,<br>
    Gabriele<br>
    <br>
    <pre class="moz-signature" cols="72">-- 
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 <a class="moz-txt-link-abbreviated" href="mailto:gabriele.bartolini@2ndQuadrant.it">gabriele.bartolini@2ndQuadrant.it</a> | <a class="moz-txt-link-abbreviated" href="http://www.2ndQuadrant.it">www.2ndQuadrant.it</a>
</pre>
  </body>
</html>

--------------030902020905080009000409--