Re: Logical replication from Rds into on-premise

[Dave Cramer <davecramer@postgres.rocks>]

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