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.

[avanpancbom]

Great work! Thank you so much for valuable information in simple words. Much appreciated.

[smormanyak]

Since 12:21 I fell into resolving right permissions for data directory. On the the one had it should be accesible for the current user and on the other it should be accessible only for 'postgres' user. I haven't managed to resolve this issue, but I have done update with 'pg_dumpall' into sql file and then just restored it within psql with \i 'sql_file'.

[TITOMIKEE]

I need to upgrade 9.2 to current version running on windows server.

[michaelcooper]

This is awesome I was needing to do this, however I have questions. How do I remove the old Postgres? Secondly, I am running an app called netbox how do I connect it to the new DB?

[nelta]

wow, easy to understand. But i have a question, how can we revert to postgresql 9.6 after upgrading (in case some of problems maybe) ?

[MikeOfThePiike]

Does pg_upgrade copy or move file from 9.6/data to 13/data ? How about when i need to upgrade a very big database ? does i duplicate data ?