Re: Seeking help extricating data from Amazon RDS Aurora/Postgres

> On Jan 29, 2024, at 11:22, Bill Mitchell <bill(at)publicrelay(dot)com> wrote:
>
> Wondering if any of the other members of this LISTSERV have tried migrating their data off of Amazon RDS Aurora Postgres with success.

Any logical-replication based solution (DMS, fivetran, in-core logical replication) will handle the problem. Although the overall migration time is high, the source database is in production for the entire time, so the actual downtime is small.

DMS is not a great solution for going PostgreSQL-to-PostgreSQL, as it has limited data type support. In-core logical replication is probably the best solution.

One thing to be aware of is when replication starts, it first needs to copy over the existing data in the tables *and* capture changes that occur during that copy. Because of that, it will retain WAL created during that copy. That can be quite a bit of disk space, so planning for that is important.