Skip to content
logo
pg_stat_monitor Documentation
Upgrade
Initializing search
    percona/pgsm-docs
    percona/pgsm-docs
    • Home
    • Comparison with pg_stat_statements
      • Release notes index
      • None
      • None
      • Version 2.0.1 (2023-05-22)
      • Version 2.0.0 (2023-03-20)
      • Version 1.x release notes
      • Install
      • Set up
    • Upgrade
      • Features
      • Views
      • Functions
    • Integration with Percona Monitoring and Management
      • Auto-create pg_stat_monitor for new databases
      • pg_stat_monitor view reference
      • Configuration
    • Uninstall
    • Contributing guide
    • Copyright and licensing information
    • Trademark policy

    Upgrade pg_stat_monitor¶

    This document describes how to upgrade pg_stat_monitor.

    Before upgrading pg_stat_monitor, learn about changes for the desired version in the release notes.

    Note

    We always recommend updating to the latest version of pg_stat_monitor to receive bug fixes and benefit from newest features and enhancements.

    1. Install the new version of the extension using the preferred installation method.

    2. Check what version of pg_stat_monitor is running in your database:

      SELECT pg_stat_monitor_version();
      

      Sample output:

       pg_stat_monitor_version
      -------------------------
       1.1.1
      (1 row)
      
    3. To upgrade the extension, use the ALTER EXTENSION command with the UPDATE TO option. 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>';
      

    Last update: December 5, 2023
    Created: December 5, 2023

    Contact Us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.

    Back to top
    Previous Set up
    Next Features
    Percona LLC and/or its affiliates © 2023 — Cookie Consent
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better. Read more about Percona Cookie Policy.