Extension Usage

How to install, load, create, update, remove PostgreSQL extensions in Pigsty?

Get Started

How to use PostgreSQL extensions out-of-the-box in Pigsty

Get Extension

How to download PostgreSQL extension packages to your local repo

Install Extension

How to install PostgreSQL extensions from local or upstream repositories.

Load Extension

Extensions using the hook mechanism must be preloaded and require a restart to take effect.

Create Extensions

How to use CREATE EXTENSION to enable PostgreSQL extensions in your database.

Update Extension

How to update PostgreSQL extensions to newer versions

Remove Extension

How to safely remove PostgreSQL extensions from a database cluster


Last modified 2025-03-07: extension update (3df74ea)