Pg_upgrade has matured to become a popular method to perform major version upgrades. This email thread considers what better upgrades would look like. Options include: Migrating analyze statistics Logical replication (requires double the disk space, managing schema changes) Multi-master replication (similar to previous, but also requires conflict resolution) Allowing the new server to read the old server’s data files Upgrade improvements have to be either significantly better in one of these measurements: faster, easier, more…
External feed Read More at the Source: https://postgr.es/p/4jF