May 2018
Intermediate to advanced
576 pages
30h 25m
English
Another system view, pg_available_extension_versions, shows all the versions available for each extension. It can be valuable when there are multiple versions of the same extension available at the same time; for example when making preparations for an extension upgrade.
When a more recent version of an already installed extension becomes available to the database server, for instance, because of a distribution upgrade that installs updated package files, the super user can perform an upgrade by issuing the following command:
ALTER EXTENSION myext UPDATE TO '1.1';
This assumes that the author of the extension taught it how to perform the upgrade.
Extensions interact nicely with logical backup and restore nicely, a topic that ...