Performing a minor version upgrade on a Debian installation v16
If you are upgrading a Debian-based system (or a compatible system such as Ubuntu), then you used a Debian package to install EDB Postgres Advanced Server. To perform a minor upgrade on these systems, use the apt-get
package manager.
Note
This procedure only performs an upgrade between minor EPAS releases. To upgrade to a later major release, use the pg_upgrade
procedure.
To list the package updates that are available for your system, open a command line, assume root privileges, and run:
Where
package_name
is the search term for which you want to list available updates. You can include wildcard values in the search to list multiple related packages with a single command. For example, use the following command to list all packages with names that start withedb
:After you identify the package(s), update them:
Where
package_name
is the name of the package you want to update. You can include wildcard values to update multiple related packages with a single command. For example, use the following command to update all packages with names that start withedb
:The output asks for confirmation to install the packages:
Confirm by entring the letter
Y
and pressing Enter.Restart your server to complete the upgrade.
For more information about using apt-get
commands and options, enter apt-get --help
at the command line.
Important
If upgrading to version 15.4 or later, run edb_sqlpatch
.
The command might respond that it has a number of patches needing to be applied, for example:
In this case, you need to run edb_sqlpatch to patch the system catalog:
For more information about using edb_sqlpatch commands and options, see edb_sqlpatch.