Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fusT3-0001zH-8P
	for pgsql-admin@arkaria.postgresql.org; Wed, 29 Aug 2018 04:52:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fusT1-0004sL-4w
	for pgsql-admin@arkaria.postgresql.org; Wed, 29 Aug 2018 04:52:31 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1fusT0-0004sE-TY
	for pgsql-admin@lists.postgresql.org; Wed, 29 Aug 2018 04:52:30 +0000
Received: from n3.nabble.com ([162.255.23.22])
	by magus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1fusSx-0003bV-PI
	for pgsql-admin@postgresql.org; Wed, 29 Aug 2018 04:52:30 +0000
Received: from n3.nabble.com (localhost [127.0.0.1])
	by n3.nabble.com (Postfix) with ESMTP id 8CE87ECC3343
	for <pgsql-admin@postgresql.org>; Tue, 28 Aug 2018 21:52:25 -0700 (MST)
Date: Tue, 28 Aug 2018 21:52:25 -0700 (MST)
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1535518345574-0.post@n3.nabble.com>
Subject: Re: Differences between Logical Decoding, Logical Replication?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Hi Team,

I wanted to know the differences between "Logical Streaming Replication
Protocol", "Logical Decoding", "Physical Streaming Replication Protocol" in
detail.

I merely know that Logical Streaming protocol was built on the primitives of
physical streaming replication protocol, but I wanted to know how it does
the process in depth.

How snapshots are managed in both Logical Streaming Replication Protocol and
Logical Decoding. 

Basically how a snapshot life cycle is managed by postgres in Logical
Replication? 
Please let me know the main in depth architectural differences between
Logical Decoding and Logical Streaming Replication Protocol..


Thanks in Advance

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html