Re: Logical replication from Rds into on-premise

From: Rama Krishnan <raghuldrag(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)postgres(dot)rocks>
Cc: Cory Nemelka <cnemelka(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Logical replication from Rds into on-premise
Date: 2021-07-27 12:27:02
Message-ID: CAJWX+EM-WuhFzQOrBgQmEZ4z8LK5obtw_xXxE1+-7ceFKjJW2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgres(dot)rocks> wrote:

>
> Dave Cramer
> www.postgres.rocks
>
>
> On Mon, 26 Jul 2021 at 18:43, Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:
>
>>
>> On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan <raghuldrag(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-07-27 12:50:02 Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load
Previous Message Dave Cramer 2021-07-27 11:38:03 Re: Logical replication from Rds into on-premise