Logical replication from Rds into on-premise

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

Dave Cramer
www.postgres.rocks

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

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

Does RDS allow logical replication

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:

On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer <davecramer@postgres.rocks>
wrote:

Does RDS allow logical replication

Yes, it does. I believe it was patched for v9.6, but v10 and above support
it out of the box, and the RDS version of PostgreSQL shares that support. I
have used it with v10 and v11, and it works exactly like the standard PG
docs say it should.

- Miles

Awesome, thanks! Can you please share docs my Rds version is 12.3

On Tue, 27 Jul, 2021, 19:00 Miles Elam, <miles.elam@productops.com> wrote: