Extension
Harness the synergistic power of PostgreSQL extensions
Pigsty allows you to harness the synergistic superpower of the Postgres extensions ecosystem with 3 things: Catalog, Repo, and pig.
Extension Catalog
The complete list of 420+ available PostgreSQL extensions
Software Repository
The APT/YUM repo that deliver PostgreSQL extensions
Package Manger
The missing package manager for PostgreSQL & Extensions
Quick Start
How to get, install, config, manage these extensions?
There are 423 PostgreSQL extensions available out-of-the-box in Pigsty:
Distro | All | PGDG | PIGSTY | CONTRIB | OTHER | MISS | PG17 | PG16 | PG15 | PG14 | PG13 |
---|---|---|---|---|---|---|---|---|---|---|---|
EL | 417 | 119 | 227 | 71 | 0 | 6 | 399 | 407 | 410 | 394 | 368 |
Debian | 410 | 103 | 236 | 71 | 0 | 13 | 397 | 400 | 403 | 391 | 363 |
Usage
Package
Download and install extensions with package alias
Download
Download Extensions from PGDG / Pigsty Repo
Install
Install Postgres Extension Packages
Config
Configure extensions and setup pre-loading
Download
Download Extensions from PGDG / Pigsty Repo
Install
Install Postgres Extension Packages
Config
Configure extensions and setup pre-loading
Create
CREATE Postgres Extension in Database
Update
Upgrade Postgres Extension
Remove
Uninstall Postgres Extension