Compatibility
Supported operating systems, kernels & arch, PostgreSQL major versions and feature sets.
Categories: Admin
Getting Started
Get Pigsty up & running based your resources and needs: preparation, provision, download, configure, and installation
Module:
Nginx: Expose Web Service with the Infra Portal
How to expose, proxy, and forward upstream & serve local path using Nginx?
Module:
Categories:
Certbot: Free HTTPS Certs
How to apply free Let’s Encrypt HTTPS certificates with certbot?
Module:
Categories:
Docker: Setup & Proxy
How to configure container support in Pigsty? and how to configure mirror & proxy for DockerHub?
Module:
Categories:
Preparation
How to prepare the nodes, network, OS distros, admin user, ports, and permissions for Pigsty.
Module:
Use PostgreSQL as Ansible Config Inventory CMDB
Use PostgreSQL instead of static YAML config file as Ansible config inventory
Categories:
Administration
Admin SOP, create & remove etcd clusters and members
Module:
Categories:
Administration
FerretDB administration playbooks, dashboards, and SOPs
Module:
Categories:
Administration
Admin SOP, create & remove MinIO clusters and members
Module:
Categories:
Administration
Node admin SOP, add & remove node, setup admin, bind vip and miscellany
Module:
Categories:
Administration
Administration standard operation procedures to manage PostgreSQL clusters in production environment.
Module:
Categories:
Administration
How to administrate Redis instances 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:
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:
Provisioning
Introduce the 4 node sandbox environment. and provision VMs with vagrant & terraform
Module:
Services & Access
Pigsty employs HAProxy for service access, offering optional pgBouncer for connection pooling, and optional L2 VIP and DNS access.
Module:
Categories:
Use PG as Grafana Backend
Use PostgreSQL instead of default SQLite, as the backend storage for Grafana
Categories:
ByteBase: PG Schema Migration
Self-hosting bytebase with PostgreSQL managed by Pigsty
Module:
Categories:
Bind a L2 VIP to Node Cluster with Keepalived
How to bind an optional L2 VIP to a node cluster with keepalived?
Module:
Categories:
Tasks
Look up common tasks and how to perform them using a short sequence of steps
Module:
PGAdmin4: PG Admin GUI Tool
Launch pgAdmin4 with docker, and load Pigsty server list into it
Module:
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:
SchemaSPY: Dump & Visualize PG Schema
Dump & visualize PostgreSQL schema with SchemaSPY
Module:
Categories:
HugePage: Enable for PostgreSQL
How to allocate precise huge pages for PostgreSQL clusters?
Module:
Categories:
PGWeb: Browser-based PG Client
Launch pgweb to access PostgreSQL via web browser
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?