Comment by tbrock

The upgrade path using logical replication is critical for minimizing downtime. The others should not be considered for production workloads.

As far as RDS goes it amazes me that, even with replicas, there are NO options for doing a zero downtime upgrade which is a major gotcha.

By this point they should buffer the writes during the critical section when the switchover happens and make this seamless for users and operators.