About
Learn about Pigsty itself in every aspect - features, history, license, privacy policy, community events, and news.
Categories: Tutorial
Inventory
Describe your infrastructure and clusters using declarative configuration files
Get Started
Deploy Pigsty single-node version on your laptop/cloud server, access DB and Web UI
Single-Node Installation
Get started with Pigsty—complete single-node install on a fresh Linux host!
Web Interface
Explore Pigsty’s Web graphical management interface, Grafana dashboards, and how to access them via domain names and HTTPS.
Getting Started with PostgreSQL
Get started with PostgreSQL—connect using CLI and graphical clients
Customize Pigsty with Configuration
Express your infra and clusters with declarative config files
Run Playbooks with Ansible
Use Ansible playbooks to deploy and manage Pigsty clusters
Offline Installation
Install Pigsty in air-gapped env using offline packages
Slim Installation
Install only HA PostgreSQL clusters with minimal dependencies
Security Tips
Three security hardening tips for single-node quick-start deployment
Deployment
Multi-node, high-availability Pigsty deployment for serious production environments.
Install Pigsty for Production
How to install Pigsty on Linux hosts for production?
Prepare Resources for Serious Deployment
Production deployment preparation including hardware, nodes, disks, network, VIP, domain, software, and filesystem requirements.
Planning Architecture and Nodes
How many nodes? Which modules need HA? How to plan based on available resources and requirements?
Setup Admin User and Privileges
Admin user, sudo, SSH, accessibility verification, and firewall configuration
Sandbox
4-node sandbox environment for learning, testing, and demonstration
Vagrant
Create local virtual machine environment with Vagrant
Terraform
Create virtual machine environment on public cloud with Terraform
Security
Security considerations for production Pigsty deployment
Tutorials
Step-by-step guides for common PostgreSQL tasks and scenarios.
Citus: Deploy HA Citus Cluster
How to deploy a Citus high-availability distributed cluster?
Quick Start
Four-step process overview for using extensions
Install
Install extension packages on cluster nodes
Getting Started
Quick start with pig, the PostgreSQL package manager