Thread: 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
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?ThanksRamaKrishnan
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?ThanksRamaKrishnanI would start here: https://www.postgresql.org/docs/12/sql-createpublication.htmlmake 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:
Dave Cramerwww.postgres.rocksOn 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?ThanksRamaKrishnanI would start here: https://www.postgresql.org/docs/12/sql-createpublication.htmlmake sure all your tables have primary keys. :DDoes RDS allow logical replication
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:
On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer <davecramer@postgres.rocks> wrote:Does RDS allow logical replicationYes, 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