I really would like to know details on how people backup, dump, migrate and upgrade DBs of this size.
On this size class (~1TB) I see PITR backups using something like Barman as the only viable alternative. (Of course you can also copy the whole VM/Disk etc)