Citus (Distributive)
Deploy native HA citus cluster with Pigsty, horizontal scaling PostgreSQL with better throughput and performance.
Module: PGSQL
Architecture
PostgreSQL cluster architectures and implmenetation details.
Module:
Categories:
Concept
Introduction to core conecpt in PostgreSQL clusters
Module:
Categories:
WiltonDB (MSSQL)
Create SQL Server Compatible PostgreSQL cluster with WiltonDB and Babelfish (Wire Protocol Level)
Module:
IvorySQL (Oracle)
Run “Oracle-Compatible” PostgreSQL cluster with the IvorySQL Kernel open sourced by HighGo
Module:
Users
Define business users & roles in PostgreSQL, which are logical objects 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:
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:
Supabase (Firebase)
How to self-host Supabase with existing managed HA PostgreSQL cluster, and launch the stateless part with docker-compose?
Module:
Use PostgreSQL as Ansible Config Inventory CMDB
Use PostgreSQL instead of static YAML config file as Ansible config inventory
Categories:
Parameters
There are 112 parameters about PostgreSQL in Pigsty
Module:
Categories:
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:
Playbook
How to manage PostgreSQL cluster with ansible playbooks
Module:
Categories:
PostgreSQL
The most advanced open-source relational database in the world with HA, PITR, IaC and more!
Module:
Kernel Forks
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:
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:
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:
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:
Use PG as Grafana Backend
Use PostgreSQL instead of default SQLite, as the backend storage for Grafana
Categories:
Bind a L2 VIP to PostgreSQL Primary with VIP-Manager
How to bind an optional L2 VIP to a PostgreSQL cluster with VIP-Manager?
Module:
Categories:
HugePage: Enable for PostgreSQL
How to allocate precise huge pages for PostgreSQL clusters?
Module:
Categories:
Citus: HA Cluster
How to deploy a native HA citus cluster with Pigsty & Patroni?
Module:
Categories:
HA Drill: 2/3 Failure
How to recover from emergency scenario with 2-node broken in a 3-node setup?