Re: Logical replication from Rds into on-premise
Awesome, thanks! Can you please share docs my Rds version is 12.3 On Tue, 27 Jul, 2021, 19:00 Miles Elam, wrote: > On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer > 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 > >
Re: Logical replication from Rds into on-premise
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, wrote: > > Dave Cramer > www.postgres.rocks > > > On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote: > >> >> On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan >> 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 >
Re: Logical replication from Rds into on-premise
On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer 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
Re: Logical replication from Rds into on-premise
Dave Cramer www.postgres.rocks On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote: > > On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan > 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
Re: Logical replication from Rds into on-premise
On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan 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
Logical replication from Rds into on-premise
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