Maintainable Toolbox: Simple & Actionable
Blazing like wildfire, illuminating all around—true to the core while constantly innovating, burning bright without end!
Infra as Code: Define and manage everything in code
Pigsty uses a declarative API, making database deployment and operations as flexible as writing code
Designed for large-scale cluster management, where Infra as Code becomes Infra as Data
- Define databases and entire infrastructure through configuration files, facilitating GitOps
- Designed for batch management, all operations can be completed via CLI, rejecting ClickOps
- Optional built-in PostgreSQL CMDB solution for programmatic management
curl -fsSL https://repo.pigsty.cc/get | bash # Install
cd ~/pigsty # Enter directory (default in home dir)
./bootstrap # Prepare dependencies (bootstrap, install Ansible)
./configure # Generate config (config file: pigsty.yml)
./install.yml # Execute deployment (based on config inventory)Simple & Easy: Up and running in minutes
One-click download and installation, deployment in minutes, all steps completed with a single command
Pre-configured templates, automatic hardware detection, and environment-based adaptation
- Ready-to-use configuration templates based on node count and various scenarios
- Can run on a single-core VM or fully utilize high-end physical machines
- Four instance parameter tuning modes: OLTP / OLAP / CRIT / TINY
| Code | PG17 | PG16 | PG15 | PG14 | PG13 | x86_64 | Arm64 |
|---|---|---|---|---|---|---|---|
| EL9 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| D12 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| U22 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| EL8 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| U24 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Bare Linux: No containers or K8s required
Runs on bare Linux systems, avoiding the additional complexity of Docker and Kubernetes
Making the right but difficult choice in the cloud-native era: adapting to each OS distribution individually
- No containers needed for reliable delivery, no K8S required for cloud-native experience
- Supports mainstream Linux distributions: EL 8/9, Debian 12, Ubuntu 22/24
- Supports x86_64/ARM64 architectures, commercial version supports domestic ARM chips
For specific OS versions, download offline packages to /tmp/pkg.tgz,bootstrap will use it automatically
| RockyLinux 9.4 / x86_64 | pigsty-pkg-v3.3.0.el9.x86_64.tgz |
|---|---|
| Ubuntu 22.04.5 / x86_64 | pigsty-pkg-v3.3.0.u22.x86_64.tgz |
| Debian 12.7 / x86_64 | pigsty-pkg-v3.3.0.d12.x86_64.tgz |
| Debian 12.7 / aarch64 | pigsty-pkg-v3.3.0.d12.aarch64.tgz |
Offline Install: Stable, hassle-free delivery
Pigsty provides offline installation packages for one-click bootstrap in environments without network access
Offline packages are snapshots from local software repositories, containing all required software and dependencies
- Eliminates lengthy downloads, avoids issues caused by upstream repository dependency changes
- Ensures installation is unaffected by external network issues, maintains software version consistency
- Commercial version offers customized offline packages for more OS versions and distributions
Admin SOP: Best practices included
Top-tier DBA experience distilled into integrated development conventions and operational SOPs
Process-driven guidance helps teams avoid common pitfalls and build solid foundations from the start
No Downtime: Online migration and resizing
Achieve zero-downtime online migration with blue-green deployment based on logical replication
Implement zero-maintenance windows with brief-interruption switchover between primary and standby
- Comprehensive semi-automated logical replication migration toolkit: migrate and upgrade without downtime
- Active switchover with only momentary interruption, eliminating extended maintenance windows
- Rolling maintenance, in-place scaling, and precise traffic management with HAPROXY
Rich Parameters: Plenty of tunable parameters
Nearly 300+ configurable parameters, with defaults suitable for most scenarios
Adjust as needed to meet even the most demanding DBA customization requirements
- YAML configuration format, easy to read, edit, and modify, works for both monolithic and distributed setups
- Configure and override at multiple levels: default, global, cluster, instance, or command line
- Rich documentation, configuration examples, self-explanatory parameter naming, and sensible defaults
Provisioning: One-click server provisioning
Built-in sandbox environment, capable of running a complete four-node simulation on a single laptop
Integrated Vagrant/Terraform sandbox solutions to provision required resources with one click
- Unified environment: consistent deployment across production, UAT, staging, testing, and development
- Complete component set, ideal as a developer's Devbox environment running on a laptop
- Multiple specifications of TF/Vagrantfiles available to provision environments of different scales
PIGSTY