Extensions

PostgreSQL extensions are add-ons that enhance the functionality of PostgreSQL databases. By installing these extensions, you can modify and extend your database system with new features, functions, and data types.

Percona Distribution for PostgreSQL includes extensions that have been tested to work together. These extensions encompass the following:

• PostgreSQL contrib modules and utilities

• Extensions authored by Percona:

  • pg_stat_monitor
  • pg_tde

• Third-party components

Percona also supports extra modules, not included in Percona Distribution for PostgreSQL but tested to work with it.

Additionally, see the list of PostgreSQL software covered by Percona Support.

Install an extension

To use an extension, install it. Run the CREATE EXTENSION command on the PostgreSQL node where you want the extension to be available.

The user should be a superuser or have the CREATE privilege on the current database to be able to run the CREATE EXTENSION command. Some extensions may require additional privileges depending on their functionality. To learn more, check the documentation for the desired extension.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert