Re: Logical replication from Rds into on-premise

[Cory Nemelka <cnemelka@xxxxxxxxx>]

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