Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication from Rds into on-premise - Mailing list pgsql-general

From Cory Nemelka
Subject Re: Logical replication from Rds into on-premise
Date
Msg-id CAMe5Gn0zK03UDhPs_ShikpeV1yLj1vkt8=YwGBDGEj9qSJ1Tdw@mail.gmail.com
Whole thread Raw
In response to Logical replication from Rds into on-premise  (Rama Krishnan <raghuldrag@gmail.com>)
Responses Re: Logical replication from Rds into on-premise
List pgsql-general
Tree view

On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan <raghuldrag@gmail.com> 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

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg-audit extension
Next
From: guntiso@latnet.lv
Date:
Subject: single-row deadlock