How to upgrade from Postgres 9.6 to Postgres13
Here's a step-by-step demo guide on how to upgrade Postgres from Version 9.5 to Version 13. In this video, we'll also cover some of the best practices before and after the Postgres upgrade.
The flow of the Demo:
Installation of Postgres 13 to migrate our older Postgres database i.e Postgres 9.6
Perform the upgrade using the latest version of the pg_upgrade utility command.
Connect and switch from Postgres 9.6 and Postgres 13 using the assigned PORT numbers.
Important: Prior to your upgrade, please make sure to backup your current database. You can use different approaches, it could be on-line, logical, or file system backup, it's up to you. As long as you can recover your current database if anything goes wrong during the upgrade process, that will be fine.