Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46401=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1coiap-0003DB-2d
	for pgsql-admin@arkaria.postgresql.org; Fri, 17 Mar 2017 03:30:19 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46401=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1coiao-0006dC-7F
	for pgsql-admin@arkaria.postgresql.org; Fri, 17 Mar 2017 03:30:18 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <jasoninmel+1@gmail.com>)
	id 1coian-0006cs-Pt
	for pgsql-admin@postgresql.org; Fri, 17 Mar 2017 03:30:17 +0000
Received: from mwork.nabble.com ([162.253.133.43])
	by makus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <jasoninmel+1@gmail.com>)
	id 1coiak-0001ho-Oa
	for pgsql-admin@postgresql.org; Fri, 17 Mar 2017 03:30:16 +0000
Received: from mben.nabble.com (unknown [162.253.133.72])
	by mwork.nabble.com (Postfix) with ESMTP id 574FA33833354
	for <pgsql-admin@postgresql.org>; Thu, 16 Mar 2017 20:30:13 -0700 (MST)
Date: Thu, 16 Mar 2017 20:30:13 -0700 (MST)
From: jasoninmel <jasoninmel+1@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1489721413358-5950172.post@n3.nabble.com>
In-Reply-To: <1398211489576882@web5g.yandex.ru>
References: <1489553982608-5949678.post@n3.nabble.com>
 <1398211489576882@web5g.yandex.ru>
Subject: Re: Postgres - Replication
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.1 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


Thanks Samed.

Perhaps the question may not be clear and sorry about that. 

What I'm looking for is an option to scale the solution to multi site
configuration where two different sites located in different geographical
locations to be able to maintain data in sync.

Currently I'm using synchronous streaming replication and one option I've
evaluated is cascading replication. 



--
View this message in context: http://www.postgresql-archive.org/Postgres-Replication-tp5949678p5950172.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin