Building Environment
How to prepare VM env for building PostgreSQL RPM/DEB extensions, EL 8/9, Debian12, Ubuntu22
Tags: Extension
Get Started
Get Started with pig, the PostgreSQL extension manager.
Module:
Why Pig?
Why would we need yet another package manager? especially for Postgres extensions?
Module:
Extension List
The complete 405 PostgreSQL Extension List available in Pigsty
Module:
Install
Get Started with pig, the PostgreSQL extension manager.
Module:
Prepare rust & pgrx
It is necessary to install rust and pgrx before building Rust extensions.
Module:
Extension Repo
How to use PostgreSQL extension YUM/APT repo on EL/Debian/Ubuntu and compatible os?
Module:
Extension Usage
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:
Roadmap
Extension Rodapmap, on our radar, backlogs, defects, changes, and retired list.
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 extensions out-of-the-box in Pigsty
Module:
RPM List
398 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
392 Available PostgreSQL Extensions Deb in Debian / Ubuntu Distributions
Module:
Get Extension
How to download PostgreSQL extension packages to your local repo
Module:
Todo List
Which extensions are coming next? and which are not planned?
Module:
Extensions
Define, Create, Install, Enable Extensions in Pigsty
Module:
Categories:
Bad Case
Not all extensions are perfect, some have defects, some are not yet supported, here are the noted bad cases.
Module:
Pigsty Command Line
The overview of pig cli tool
Module:
Contrib List
PostgreSQL built-in extension list
Module:
Install Extension
How to install PostgreSQL extensions from local or upstream repositories.
Module:
Load Extension
Extensions using the hook mechanism must be preloaded and require a restart 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 Extensions
How to use CREATE EXTENSION to enable PostgreSQL extensions in your database.
Module:
Update Extension
How to update PostgreSQL extensions to newer versions
Module:
Pigsty Administration
How to manage pigsty with pig sty subcommand?
Module:
Remove Extension
How to safely remove PostgreSQL extensions from a database cluster
Module:
Changelog
Pigsty extension repository changelog
Module:
Metadata Desc
Available Metadata for PostgreSQL Extensions, and explain each attribute.
Module:
Compatibility
Linux Distribution compatibility matrix