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 ) id 1fQCGr-0001nG-89 for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:45:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQCGq-0001n4-0U for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:45:08 +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 ) id 1fQCGp-0001mr-Oq for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:45:07 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQCGl-0008LH-2e for pgsql-admin@postgresql.org; Tue, 05 Jun 2018 13:45:07 +0000 Received: from mail.etecsa.cu (unknown [192.168.91.10]) by imx6.etecsa.cu (Postfix) with ESMTP id E948023C; Tue, 5 Jun 2018 09:44:57 -0400 (CDT) Received: from webmailrc.etecsa.cu (unknown [192.168.97.37]) (Authenticated sender: gilberto.castillo) by mail.etecsa.cu (Postfix) with ESMTPA id B0EAB3294444; Tue, 5 Jun 2018 09:44:57 -0400 (CDT) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Tue, 05 Jun 2018 09:44:57 -0400 From: gilberto.castillo@etecsa.cu To: bala jayaram Cc: pgsql-admin Subject: Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS In-Reply-To: References: Message-ID: X-Sender: gilberto.castillo@etecsa.cu User-Agent: Roundcube Webmail/1.2.5 X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 125538 [Jun 05 2018] X-KLMS-AntiSpam-Version: 5.8.1.0 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 136 136 c82d77b5fe5df28ce564602406d3c21afb9c8b73, Auth:dkim=none, DmarcAF: none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2018/05/25 10:21:04 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2018/06/05 08:26:00 #8584512 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk See you, Please https://medium.com/@gilbertocastillo El 2018-06-05 09:41, bala jayaram escribió: > Hi Team, > > Any update on this please? > > Thanks > Bala > > On Thu, May 31, 2018 at 2:44 PM, bala jayaram > wrote: > >> Hi Team, >> >> Recently we tried to migrate EC2/Postgres with Master/2Slave >> (Streaming Replication /Hot_standby) into Native RDS based server. >> But while we try to use Database Migration Service, our aim is to >> use one of slave as SOURCE for DMS , So AWS/DMS requires that in >> source machine to be with two parameters changed - >> max_replication_slot > 0 & wal_level = logical. If i change those >> parameters in Slave, will the master will recognize slave with >> Logical streaming? Am not sure master with Streaming >> Replication(Physical) will Sync with Slave with Logical Replication? >> >> >> Also if change physical streaming to Logical Streaming, will there >> be any change in data blocks or data in postgres? >> >> Thanks >> Bala