On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
> Hello All.
>
>
> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of pg_upgrade.
why not pg_upgrade ? If the size is near the 3TB mark as you say, pg_upgrade is the fastest IMHO.
>
> - Less downtime.
> - Approx database size are 1-3TB.
>
> Thanks for your help..!!!
>
>
> Regards,
> Pawan
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt