From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
To: CS DBA <cs_dba@consistentstate.com>
Cc: Rangi, Jai <jrangi@automotive.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres Replication Options
Date: Thu, 10 Feb 2011 14:56:05 +0100
Message-ID: <4D53EE75.9070007@2ndQuadrant.it> (raw)
In-Reply-To: <4D52C684.1070808@consistentstate.com>
References: <11F808DFED68574E8357241F5B39CAF5B96A24@mail-001.corp.automotive.com>
<4D523E22.5000106@2ndQuadrant.it>
<4D52C684.1070808@consistentstate.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gabriele.bartolini@2ndQuadrant.it, cs_dba@consistentstate.com, jrangi@automotive.com
Subject: Re: Postgres Replication Options
In-Reply-To: <4D53EE75.9070007@2ndQuadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox