This document describes how to upgrade
pg_stat_monitor, learn about changes for the desired version in the release notes.
We always recommend updating to the latest version of
pg_stat_monitor to receive bug fixes and benefit from newest features and enhancements.
Install the new version of the extension using the preferred installation method.
Check what version of
pg_stat_monitoris running in your database:
pg_stat_monitor_version ------------------------- 1.1.1 (1 row)
To upgrade the extension, use the ALTER EXTENSION command with the
UPDATE TOoption. Replace the
<version>placeholder with the desired version of the extension.
Your PostgreSQL user must have the privileges of a superuser or a database owner to run the command:
ALTER EXTENSION pg_stat_monitor UPDATE TO '<version>';
Created: December 5, 2023