Building Environment
How to prepare VM env for building PostgreSQL RPM/DEB extensions, EL 8/9，Debian12，Ubuntu22。
Tags: Extension
Metadata Desc
Available Metadata for PostgreSQL Extensions, and explain each attribute.
Module:
Extension List
The complete 346 PostgreSQL Extension List available in Pigsty
Module:
Prepare rust & pgrx
It is necessary to install rust and pgrx before building Rust extensions.
Module:
Use Extension
How to install, load, create, update, remove PostgreSQL extensions in Pigsty?
Module:
Build & Packaging
Prepare PostgreSQL rpm/deb pacakge building environment, and some packaging hints
Module:
Build PLv8
Build the Javascript procedural language extension PLv8 for PostgreSQL.
Module:
Build PostgresML
There are some extra settings to build PostgresML on EL8 and EL9.
Module:
Get Started
How to use PostgreSQL extension in an out-of-the-box manner with Pigsty!
Module:
RPM List
338 Available PostgreSQL Extension RPM in RHEL & Compatible Distributions
Module:
Build ParadeDB
There are some important ParadeDB extensions that need to be built and packaged.
Module:
DEB List
326 Available PostgreSQL Extensions Deb in Debian / Ubuntu Distributions
Module:
Download Extension
How to download new extension packages to Pigsty’s local software repository?
Module:
Extension Repo
How to
Module:
Extensions
Define, Create, Install, Enable Extensions in Pigsty
Module:
Categories:
Contrib List
PostgreSQL built-in extension list
Module:
Install Extension
How to install a extension from local repo, or directly from the Internet upstream repo.
Module:
Load Extension
Some extensions that use hook mechanism must be preloaded and restarted to take effect.
Module:
Build DuckDB FDW
How to build DuckDB FDW extension and its dependencies libduckdb.so
Module:
Build Parquet S3 FDW
Build Parquet S3 FDW extension alone with its deps: libarrow, libparquet, 以及 libaws-cpp
Module:
Create Extension
How to use CREATE EXTENSION to actually enable a PostgreSQL extensions.
Module:
Update Extension
How to update an existing extension?
Module:
Remove Extension
How to safely remove a PostgreSQL extension from a database cluster?
Module:
Pre-defined Stacks
How to use the predefined extension stacks in Pigsty?