> Edit: Possibly misinformed but the last deep dive we did indicated there was not a way to use logical replication for seamless upgrades. Will have to research.
We seem to have been misguided by all of the Amazon RDS and Aurora documentation. It seems Amazon prefers to implement postgres logical replication through their database migration service. All upgrades are typically done through pg_upgrade which does require downtime.
Interesting. I can't wait to see how PG12 influences future offerings from the cloud providers for more seamless major version upgrades.
It is possible since PG10
https://severalnines.com/database-blog/how-upgrade-postgresq...