> On Jan 29, 2024, at 11:22, Bill Mitchell <b...@publicrelay.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.
