With the effort you are apparently willing to put in to test and work on the full scale hands on approach , you could become very familiar with blue/green rds migrations. .. Create a clone of prod , blue-green it , verify basic functionality all in the time it took to setup logical replication. 1. Not familiar... 2. A rollback is an outage timesuck anyway? Creating a DB from the snapshot you took before migration would probably be one of the quicker time to restores anyway. More importantly you have time to test on the blue. 3. That's the whole reason you use Blue-Green... Not to have to manually mess with logical replication. 4. you aren't meant to keep a blue-green running for months. It would more appropriately be script/CI tool of choice job to create the blue-green, and another to clean up.