Using Extensions with Cloud

pgEdge Cloud databases include pre-installed PostgreSQL extensions. Before using an extension, you must create the extension in each database where the extension will be used. To create an extension, invoke the following command on the psql command line:

CREATE EXTENSION extension_name;

For example, to create the pgvector extension, use the following command:

CREATE EXTENSION vector;

To review a list of installed extensions, use the psql command line client to display the shared_preload_libraries parameter with the SHOW command:

accts=# SHOW shared_preload_libraries;
shared_preload_libraries
-------------------------------------------------------------------------------
pg_stat_statements, pg_readonly, pg_failover_slots, spock, vector, postgis-3
(1 row)

For detailed information about using each extension, visit the project site links provided in the table.

pgEdge and Community Extensions

The following table describes the pgEdge and community extensions available in pgEdge Cloud. Extension names match the name used in CREATE EXTENSION statements:

PostgreSQL Contrib Modules

pgEdge Cloud databases also include the standard PostgreSQL contrib modules. The following table describes the available contrib modules and includes links for more information:

Coming Soon

The following extensions are included in the pgEdge Cloud container image but require shared_preload_libraries configuration changes that are not yet available through the pgEdge Cloud interface. These extensions will be supported in a future update.