There are multiple ways to upgrade a PostgreSQL database from the old version 15 to the newer version 16, and the easiest one is by using pg_upgrade. This tool performs a rapid upgrade to a later PostgreSQL major version by reusing the old user data files.
In this step-by-step tutorial for Ubuntu (or Debian) systems, we will:
- Install the new PostgreSQL version alongside the old one
- Check and migrate any differences in config files
- Migrate the actual PostgreSQL data (users, tables, etc.)
- Switch to the newly installed version
- Do some post-installation maintenance
- Remove the old PostgreSQL version and data
Access the full tutorial for a one-time fee. Pay once, and you'll get lifetime access to everything!
7-day money-back guarantee. The price is exclusive of VAT.
Already have an account? Log in.
What people say
“THANK YOU for your tutorial. It worked flawlessly! Everything made sense and I appreciate the work.”
“Thank you for your upgrade instructions from PostgreSQL 15 to 16, your guide works perfectly. Thanks for your excellent work!”
“Just wanted to thank you for explaining the PostgreSQL 14 to 15 upgrade process on your web site. It really helped me out.”
“Thanks for your tutorial on updating PostgreSQL from 11 to 12 on a Debian machine. That made an anxious time a little easier.”
“I’ve been miserable for the last two days because I needed to update Postgres on my servers but then I found your tutorials and was able to update Postgres on 2 separate servers from v12 to v15 in just two hours, without much expertise on my side. I just wanted to let you know that your guide made my day much easier and I haven’t encountered many guides that get me to my goal as well as your guide!”
“I just followed your guidance on updating PostgreSQL from v13 to v14. I don't know too much about databases but your guidance is fantastic, concise, to the point and allowed me to complete the upgrade without any problems.”
“Thank you for your tutorial about upgrading PostgreSQL.”
“I upgraded from 11 to 13 with your tutorial and it worked!”
“I've used this tutorial several times to upgrade PostgreSQL databases. It's better than anything else I've found on the Internet. It's a great piece of work, thanks!”