Enabling extensions

RayDB supports a range of PostgreSQL extensions that can be enabled to extend database functionality. This guide explains how to check available extensions and enable them for your cluster.

Checking Available Extensions

To see a list of supported extensions in your RayDB cluster, run:

SELECT * FROM pg_available_extensions;

Enabling an Extension

To enable an extension, use the CREATE EXTENSION command:

CREATE EXTENSION IF NOT EXISTS extension_name;

Example:

CREATE EXTENSION IF NOT EXISTS hstore;

Managing Extensions

• List Installed Extensions:

  SELECT * FROM pg_extension;

• Remove an Extension:

  DROP EXTENSION IF EXISTS extension_name;

Best Practices

• Only enable necessary extensions to minimize security risks and performance overhead.
• Verify compatibility before enabling extensions, as some may require additional privileges.
• Regularly update extensions when upgrading PostgreSQL versions.

For more details on managing database configurations, see Managing PostgreSQL Versions.