Nginx: Expose Web Service
How to expose, proxy, and forward web services using Nginx?
Categories: Admin
Compatibility
Supported operating systems, kernels & arch, PostgreSQL major versions and feature sets.
Module:
Categories:
Getting Started
Get Pigsty up & running based your resources and needs: preparation, provision, download, configure, and installation
Module:
Docker: Container Support & Proxy
How to configure container support in Pigsty? and how to configure 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:
Use PG as Grafana Backend
Use PostgreSQL instead of default SQLite, as the backend storage for Grafana
Categories:
Bind a L2 VIP to Node Cluster with Keepalived
Module:
Categories:
Administration
Administration standard operation procedures to manage PostgreSQL clusters in production environment.
Module:
Categories:
Bind a L2 VIP to PostgreSQL Primary with VIP-Manager
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:
ByteBase: PG Schema Migration
Self-hosting bytebase with PostgreSQL managed by Pigsty
Module:
Categories:
Task & Tutorial
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:
SchemaSPY: Dump & Visualize PG Schema
Dump & visualize PostgreSQL schema with SchemaSPY
Module:
Categories:
PGWeb: Browser-based PG Client
Launch pgweb to access PostgreSQL via web browser