Performing a minor version upgrade on a Debian installation v16
If you're 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 performs an upgrade only between minor EDB Postgres Advanced Server 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:
apt-get install --simulate <package_name>
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
:apt-get install --simulate edb*
After you identify the packages, update them:
apt-get install <package_name>
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
:apt-get update edb*
The output asks for confirmation to install the packages:
After this operation, <number> kB of additional disk space will be used. Do you want to continue? [Y/n] Y
Type
Y
and press Enter.To complete the upgrade, restart your server.
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:
* database edb
0 patches were previously applied to this database.
58 patches need to be applied to this database.
In this case, you need to run edb_sqlpatch
to patch the system catalog:
edb_sqlpatch -af
For more information about using edb_sqlpatch
commands and options, see edb_sqlpatch.