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.