public inbox for [email protected]  
help / color / mirror / Atom feed
From: Thomas Harold <[email protected]>
To: Ben Chobot <[email protected]>
Cc: pgsql-general General <[email protected]>
Subject: Re: PG replication across DataCenters (section 25 in the manual)
Date: Mon, 09 Dec 2013 11:39:20 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAD7Ssm9S__ZQCOq2GEN0G0rrs_4U6aqXiLaX0hh0Ts8JH_LY2w@mail.gmail.com>
	<A737B7A37273E048B164557ADEF4A58B17C5ED75@ntex2010i.host.magwien.gv.at>
	<[email protected]>
	<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-general>

On 12/9/2013 11:24 AM, Ben Chobot wrote:
>
> Out of curiosity what did you find unclear about
> http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?

Perhaps the "Per-table granularity" line in the matrix (Table 25-1) 
might be better written as:

"Synchronization Granularity"

Columns 1-3 and 5 could say "Entire Cluster".  Column 4 might say 
"Selected tables (Slony)", and I'm not sure off-hand what granularity #6 
(Bucardo) is capable of.  Column #7 might just say "Varies".

For someone not familiar with what exactly WAL files are, it's not clear 
that solution #3 is an all-or-nothing approaches at the cluster level. 
Now that I've refreshed my memory on how WAL files work (and at what 
level in the pgsql cluster), I understand why #3 works the way it does.


-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



view thread (36+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PG replication across DataCenters (section 25 in the manual)
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox