pg_upgrade is a pretty reasonable compromise, but it would be nice if an upgrade didn&#x27;t require your entire database be taken offline for the duration. I can install a new MS SQL Server instance, attach a database from the old instance and be going in under a minute of downtime - this is literally the only pain point I have with Pq, but considering I don&#x27;t typically upgrade EVERY release (I still have 9.4 instances that have no reason to be upgraded to 9.5 since the applications aren&#x27;t in-house) it&#x27;s not typically a huge deal.