On 6/9/19 11:36 PM, Pawan Sharma wrote:
Hello All.What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of pg_upgrade.- Less downtime. - Approx database size are 1-3TB.
If you really don't want to do pg_upgrade, then a possibility is multi-threaded pg_dump using directory format, followed by a parallel rsync if required, and then multi-threaded pg_restore.
-- Angular momentum makes the world go 'round.
