> On Jan 29, 2024, at 11:22, Bill Mitchell <bill@publicrelay.com> wrote:
>
> Wondering if any of the other members of this LISTSERV have tried migrating their data off of Amazon RDS Aurora
Postgreswith success.
Any logical-replication based solution (DMS, fivetran, in-core logical replication) will handle the problem. Although
theoverall 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
replicationis 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*
capturechanges that occur during that copy. Because of that, it will retain WAL created during that copy. That can be
quitea bit of disk space, so planning for that is important.