Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3rj-0002Ll-Nv for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:39:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vq3rj-0002EJ-61 for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:39:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3rh-0002Ck-HO for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:39:25 +0000 Received: from mail.nybeta.com ([207.97.179.66]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3re-00057D-Eb for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:39:25 +0000 Received: from amavisd.intra.nybeta.com (unknown [127.0.0.1]) by mail.nybeta.com (Postfix) with ESMTP id 98E7F4032C; Mon, 9 Dec 2013 16:39:21 +0000 (UTC) X-Virus-Scanned: amavisd-new at nybeta.com Received: from mail.nybeta.com ([127.0.0.1]) by amavisd.intra.nybeta.com (mail.nybeta.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id KbevdCe9wO91; Mon, 9 Dec 2013 11:39:21 -0500 (EST) Received: from [172.30.6.5] (unknown [172.30.6.5]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: thomas-lists@nybeta.com) by mail.nybeta.com (Postfix) with ESMTPSA id 61A1040028; Mon, 9 Dec 2013 11:39:21 -0500 (EST) Message-ID: <52A5F238.2010603@nybeta.com> Date: Mon, 09 Dec 2013 11:39:20 -0500 From: Thomas Harold User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: Ben Chobot CC: pgsql-general General Subject: Re: PG replication across DataCenters (section 25 in the manual) References: <52A5EB31.7070505@nybeta.com> <9F208972-32D3-4295-A30D-BCDAEF139E9F@silentmedia.com> In-Reply-To: <9F208972-32D3-4295-A30D-BCDAEF139E9F@silentmedia.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general