Yeah, was just about to post this about pg_upgrade. In addition, there was a front page post on HN recently about Adyen upgrading their 50 terabyte postgres instance with minimal downtime: https://news.ycombinator.com/item?id=29923303