3 ms·
> 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
by outworlder 5y ago
> 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.
It is possible since PG10
https://severalnines.com/database-blog/how-upgrade-postgresql10-postgresql11-zero-downtime https://severalnines.com/database-blog/how-upgrade-postgresq...
- bmcahren 5y agoWe 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.