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