Re: Migrating local PG instance to AWS RDS?

From: Ron Nollen <nollenr(at)gmail(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Migrating local PG instance to AWS RDS?
Date: 2021-05-27 22:44:27
Message-ID: CAPkjKJm_RcZoJhqmziwWb1J=Bv0EA_rqyLbai6D98tsKFVxExw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Data Migration Service (DMS) is one way to do it. You can do a full with
CDC (change data capture) and then cut over when you are ready.

https://aws.amazon.com/getting-started/hands-on/move-to-managed/migrate-postgresql-to-amazon-rds/

Cheers,
Ron.

On Thu, May 27, 2021 at 2:59 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:

> 13.2
>
> On Thu, May 27, 2021 at 2:58 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> On 5/27/21 4:49 PM, Wells Oliver wrote:
>> > Anyone have a handy write-up or useful experience to share in migrating
>> > local PG databases to Amazon's RDS?
>> >
>> > I was thinking of making a failover in RDS and promoting it after
>> > replication or something to that effect, but I thought I would see if
>> > there's some more canonical approach.
>>
>> What version?
>>
>>
>> --
>> Angular momentum makes the world go 'round.
>>
>>
>>
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2021-05-27 22:56:25 Re: Migrating local PG instance to AWS RDS?
Previous Message Wells Oliver 2021-05-27 21:59:01 Re: Migrating local PG instance to AWS RDS?