Getting Started
Get Pigsty up & running based your resources and needs: preparation, provision, download, configure, and installation
Pigsty Document v3.2
“PostgreSQL In Great STYle”: Postgres, Infras, Graphics, Service, Toolbox, it’s all Yours.
—— Battery-Included, Local-First PostgreSQL Distribution as an Open-Source RDS Alternative
Repo | Demo | Blog | CN Blog | Discuss | Discord | GPTs | Roadmap | 中文文档
Get Started with the latest release:
curl -fsSL https://repo.pigsty.io/get | bash
Setup: Install | Offline Install | Preparation | Configuration | Playbook | Provision | Security | FAQ
Modules: PGSQL | INFRA | NODE | ETCD | MINIO | REDIS | FERRET | DOCKER | APP
About: Features | History | Event | Community | Privacy Policy | License | Sponsor | Support & Subscription
Concept: Architecture | Cluster Model |Local CA | IaC | HA | PITR | Service Access | Access Control
Reference: Compatibility | Parameters | Extensions | FHS | Comparison | Cost | Glossary
About Pigsty
Learn about Pigsty itself: features, values, history, license, privacy policy, events, and news.
Concept
Learn about core concept about Pigsty: architecture, cluster models, infra, PG HA, PITR, and service access.
Configuration
Batteries-included config templates for specific scenarios, and detailed explanations.
References
Detailed information and list: supported OS distros, available modules, monitor metrics, extensions, cost compare & analysis, glossary
Module: PGSQL
The most advanced open-source relational database in the world with HA, PITR, IaC and more!
Kernel: PGSQL
How to use another PostgreSQL “kernel” in Pigsty, such as Citus, Babelfish, IvorySQL, PolarDB, Neon, and Greenplum
Extension: PGSQL
There are 340 PostgreSQL extensions available in Pigsty, with out-of-box RPM/DEB packages"
Module: INFRA
Independent modules which providers infrastructure services: NTP, DNS, and the modern observability stack ——Grafana & Prometheus
Module: NODE
Tune nodes into the desired state and monitor it, manage node, vip haproxy, and exporters.
Module: ETCD
Pigsty has built-in etcd support, which is a reliable distributive consensus storage (DCS), empowering PostgreSQL HA.
Module: MINIO
Pigsty has built-in MinIO support. MinIO is an S3 OSS alternative which is used as an optional PostgreSQL backup repo
Module: REDIS
Pigsty has built-in Redis support, which is a high-performance data-structure server. Deploy redis in standalone, cluster or sentinel mode.
Module: FERRET
Pigsty has built-in FerretDB support, which is a MongoDB compatiable middleware based on PostgreSQL.
Module: DOCKER
Docker Daemon services, which allows you to pull-up stateless software in additional to PostgreSQL.
Module: Pro/Beta
Extra modules available in Pigsty Pro or in development.
Task & Tutorial
Look up common tasks and how to perform them using a short sequence of steps
Software & Tools
Software and tools that use PostgreSQL can be managed by the docker daemon
Visualization Applet
Run data analysis & visualization, data app demo with Pigsty
Release Notes
Pigsty release note history
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.