There are multiple ways to upgrade a PostgreSQL database from the old version 11 to the newer version 12, 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.