Re: Logical replication from Rds into on-premise

[Rama Krishnan <raghuldrag@xxxxxxxxx>]

Hi Dave, 

Rds support logical replication but the question of how to make replication between RDS into on premise 

On Tue, 27 Jul, 2021, 17:08 Dave Cramer, <davecramer@postgres.rocks> wrote:

Dave Cramer

www.postgres.rocks

On Mon, 26 Jul 2021 at 18:43, Cory Nemelka <cnemelka@xxxxxxxxx> wrote:

On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan <raghuldrag@xxxxxxxxx> wrote:

Hi all, 

I have a postgres server on Aws RDS no i want to replicate the data or logical replication into the on-premise server. I have gone through DMS provides the service buy it pricing was high. Do we have any option or method to achieve this?

Thanks 

RamaKrishnan

I would start here: https://www.postgresql.org/docs/12/sql-createpublication.html

make sure all your tables have primary keys. :D

Does RDS allow logical replication