Citus (Distributive)
Deploy native HA citus cluster with Pigsty, horizontal scaling PostgreSQL with better throughput and performance.
Module: PGSQL
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:
Architecture
PostgreSQL cluster architectures and implmenetation details.
Module:
Categories:
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:
WiltonDB (MSSQL)
Create SQL Server Compatible PostgreSQL cluster with WiltonDB and Babelfish (Wire Protocol Level)
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:
IvorySQL (Oracle)
Run “Oracle-Compatible” PostgreSQL cluster with the IvorySQL Kernel open sourced by HighGo
Module:
Extension Repo
How to
Module:
Users
Define business users & roles in PostgreSQL, which is the object created by SQL CREATE USER/ROLE
Module:
Categories:
Databases
Define business databases in PostgreSQL, which is the object create by SQL CREATE DATABASE
Module:
Categories:
Services
Define and create new services, and expose them via haproxy
Module:
Categories:
Extensions
Define, Create, Install, Enable Extensions in Pigsty
Module:
Categories:
Authentication
Host-Based Authentication in Pigsty, how to manage HBA rules in Pigsty?
Module:
Categories:
Configuration
Configure your PostgreSQL cluster & instances according to your needs
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:
PolarDB PG (RAC)
Replace vanilla PostgreSQL with PolarDB PG, which is an OSS Aurora similar to Oracle RAC
Module:
Postgres
Posts about Pigsty and PostgreSQL
Categories:
PolarDB O(racle)
The commercial version of PolarDB for Oracle, only available in Pigsty Enterprise Edition.
Module:
Use PostgreSQL as Ansible Config Inventory CMDB
Use PostgreSQL instead of static YAML config file as Ansible config inventory
Categories:
Supabase (Firebase)
How to self-host Supabase with existing managed HA PostgreSQL cluster, and launch the stateless part with docker-compose?
Module:
Use PG as Grafana Backend
Use PostgreSQL instead of default SQLite, as the backend storage for Grafana
Categories:
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:
Extension List
List of PostgreSQL extensions supported by Pigsty, and their compatibility on different OS distros.
Module:
Categories:
Greenplum (MPP)
Deploy and monitoring Greenplum/YMatrix MPP clusters with Pigsty
Module:
Module: PGSQL
The most advanced open-source relational database in the world with HA, PITR, IaC and more!
Module:
Playbook
How to manage PostgreSQL cluster with ansible playbooks
Module:
Categories:
Kernel: PGSQL
How to use another PostgreSQL “kernel” in Pigsty, such as Citus, Babelfish, IvorySQL, PolarDB, Neon, and Greenplum
Module:
Cloudberry (MPP)
Deploy Cloudberry MPP cluster, which is forked from Greenplum.
Module:
Extension: PGSQL
There are 340 PostgreSQL extensions available in Pigsty, with out-of-box RPM/DEB packages"
Module:
Administration
Administration standard operation procedures to manage PostgreSQL clusters in production environment.
Module:
Categories:
High Availability
Pigsty uses Patroni to achieve high availability for PostgreSQL, ensuring automatic failover.
Categories:
Neon (Serverless)
Self-Hosting serverless version of PostgreSQL from Neon, which is a powerful, truly scalable, and elastic service.
Module:
Bind a L2 VIP to PostgreSQL Primary with VIP-Manager
Module:
Categories:
Update Extension
How to update an existing extension?
Module:
Access Control
Built-in roles system, and battery-included access control model in Pigsty.
Module:
Categories:
Backup & PITR
How to perform base backup & PITR with pgBackRest?
Module:
Categories:
Migration
How to migrate existing postgres into Pigsty-managed cluster with mimial downtime? The blue-green online migration playbook
Module:
Categories:
Monitoring
How PostgreSQL monitoring works, and how to monitor remote (existing) PostgreSQL instances?
Module:
Categories:
Point-in-Time Recovery
Pigsty utilizes pgBackRest for PostgreSQL point-in-time recovery, allowing users to roll back to any point within the backup policy limits.
Module:
Categories:
Remove Extension
How to safely remove a PostgreSQL extension from a database cluster?
Module:
Dashboards
Grafana dashboards provided by Pigsty
Module:
Categories:
Services & Access
Pigsty employs HAProxy for service access, offering optional pgBouncer for connection pooling, and optional L2 VIP and DNS access.
Module:
Categories:
Metrics
Pigsty PGSQL module metric list
Module:
Categories:
Access Control
Pigsty has moderate security best-practice: password & certs, built-in ACLs, encrypted network traffics and cold backups
Categories:
FAQ
Pigsty PGSQL module frequently asked questions
Module:
Categories:
Pre-defined Stacks
How to use the predefined extension stacks in Pigsty?