> Upgrading large postgres databases (100GB+) takes awfully long time > when doing dump/restore. I was wondering if this process can be > optimized by directly dumping to a new version of Pg database > directly on another server without having to dump to the filesystem > and then restore it.
From the fine documentation in the section entitled "Migration Between Releases"
> The least downtime can be achieved by installing the new server in > a different directory and running both the old and the new servers > in parallel, on different ports. Then you can use something like > > pg_dumpall -p 5432 | psql -d postgres -p 6543 > > to transfer your data.