# Pigsty v1.5.1 Documentation
> Historical documentation frozen at Pigsty v1.5.1.
---
## Pigsty v1.5.1 Documentation
**Battery-Included Open-Source PostgreSQL Distribution**
> Latest Version: [v1.5.1](https://github.com/Vonng/pigsty/releases/tag/v1.5.1) | [Github Repo](https://github.com/Vonng/pigsty) | [Demo](http://demo.pigsty.cc)
>
> Documentation: [EN Docs](https://pigsty.cc/) | [中文文档](https://pigsty.cc/#/zh-cn/) | [Github Pages](https://vonng.github.io/pigsty/#/)
## What is Pigsty?
[](/docs/s-feature/)
**Pigsty** is battery-included open-source database [distribution](/docs/s-feature/#postgresql-distribution), with the latest [PostgreSQL](https://www.postgresql.org/) kernel, [TimescaleDB](https://www.timescale.com), [PostGIS](https://postgis.net/), [Citus](https://www.citusdata.com/) & 100+ extensions, along with an entire [Infra](/docs/c-infra/): Grafana, Prometheus, Loki, Ansible, [Docker](/docs/t-docker/) to support your databases & [applications](/docs/s-feature/#versatile-scenario). It also includes common tools for [data analysis](/docs/s-feature/#data-analysis).
Pigsty is a [monitoring](/docs/s-feature/#ultimate-observability) & management [SRE Solution](/docs/s-feature/#sre-solution). Which includes an unparalleled [monitoring](/docs/s-feature/#open-source-rds) system with ultimate observability, and [high-available](/docs/c-pgsql/#high-availability) PostgreSQL with self-healing architecture. You can deploy various clusters & instances: [primary, replica](/docs/d-pgsql/#m-s-replication), [standby](/docs/d-pgsql/#sync-standby), [offline](/docs/d-pgsql/#offline-replica), [delayed](/docs/d-pgsql/#delayed-cluster), [cascade](/docs/d-pgsql/#cascade-instance), and even [Citus](/docs/d-pgsql/#citus-deployment), [Redis](/docs/d-redis/), and [Greenplum](/docs/d-matrixdb/) clusters.
Pigsty is a handy [toolbox](/docs/s-feature/#developer-toolbox) for developers. It treats [**Database as Code**](/docs/s-feature/#database-as-code), Infra as Data. You just [describe](/docs/v-config/) what database you want, and pigsty will create it for you. You can download, install, deploy, scale, backup, migration with [one command](/docs/s-install/). It can be deployed [everywhere](/docs/s-feature/#ubiquitous-deployment): a 10k+ core prod env or local 1C/2G VM, [cloud](/docs/d-sandbox/#cloud-sandbox), or [on-premises](/docs/d-sandbox/#local-sandbox).
Pigsty is a [secure](/docs/s-feature/#safty) & [thrifty](/docs/s-feature/#safty) alternative to [Cloud RDS](/docs/s-feature/#open-source-rds)/PaaS. It can empower a single DEV/DBA to manage hundreds of databases clusters, with all data under your own control. It can [save](/docs/s-feature/#safty) 50% - 80% cost compared to cloud RDS using ECS or on-premise deployment. And the software itself is completely [open-source](https://github.com/Vonng/Capslock/blob/master/LICENSE) & free!
Check [FEATURES](/docs/s-feature/) for more detail.
Distribution
[](/docs/c-infra/#overview)
Observability
[](http://demo.pigsty.cc)
High Availability
[](/docs/c-pgsql/#high-availability)
Architecture
[](/docs/c-arch/)
Sandbox
[](/docs/d-sandbox/)
Provisioning
[](/docs/d-deploy/)
User Interface
[](/docs/s-install/)
Application
[](/docs/t-application/)
Download Packages Directly
Pigsty source & software packages can be downloaded directly via `curl` in case of no Internet connection:
```bash
curl -SL https://github.com/Vonng/pigsty/releases/download/v1.5.1/pkg.tgz -o /tmp/pkg.tgz
curl -SL https://github.com/Vonng/pigsty/releases/download/v1.5.1/pigsty.tgz | gzip -d | tar -xC ~
```
Mange More Nodes
You can add more nodes to Pigsty with [`nodes.yml`](/docs/p-nodes/#nodes) after installing the meta node with [`infra.yml`](/docs/p-infra/#infra).
```bash
./nodes.yml -l pg-test # init 3 nodes of cluster pg-test
```
Define Postgres Cluster
You can define a HA Postgres Cluster with streaming replication in a few lines of code:
```yaml
pg-test:
hosts:
10.10.10.11: {pg_seq: 1, pg_role: primary}
10.10.10.12: {pg_seq: 2, pg_role: replica}
10.10.10.13: {pg_seq: 3, pg_role: replica}
vars:
pg_cluster: pg-test
```
You can create Postgres with different [roles](/docs/d-pgsql/) by declaring them: primary, replica, standby, delayed, offline, cascade, etc...
Deploy Databases Clusters
You can deploy different types of databases & clusters with corresponding playbooks.
* [`pgsql.yml`](/docs/p-pgsql/#pgsql): Deploy HA PostgreSQL clusters.
* [`redis.yml`](/docs/p-redis/#redis): Deploy Redis clusters.
* [`pgsql-matrixdb.yml`](/docs/p-pgsql/#pgsql-matrixdb): Deploy matrixdb data warehouse (greenplum7).
```bash
./pgsql.yml -l pg-test # init 1-primary & 2-replica pgsql cluster
./redis.yml -l redis-test # init redis cluster redis-test
./pgsql-matrixdb.yml -l mx-* # init MatrixDB cluster mx-mdw,mx-sdw .....
```