PIGSTY

Pigsty Docs

Pigsty v3.5 Documentation

Postgres In Great STYle —— Postgres Infra Graphic Service Toolbox, Yours

Introduction

Pigsty (/ˈpɪɡ staɪ/) is a Battery-Included, FOSS PostgreSQL Distribution as a Local-First RDS Alternative.

Values

Why using pigsty? The 8 core value proposition of Pigstys

Features

Key features, Highlights and Technical details

References

Architecture, Use Cases, Comparisons, and other references

About

License, Release, Community, News, Author, Service, etc...

Pigsty assembles all the superpowers from the PostgreSQL and Database world, provides everything you'll need to build your own Data Infra.

Just use Postgres for Everything! and Self-Hosting it like a Pro!

Installation

Single node installation: Prepare an ssh-accessible node with fresh installed Linux, run as user with nopass ssh and sudo privileges:

install
curl -fsSL https://repo.pigsty.io/get | bash;
cd ~/pigsty; ./bootstrap; ./configure; ./install.yml;

Download, Bootstrap, Configure and Install. Pigsty Installed! You can add more nodes and database clusters later.

Explore the User Interface, check port 5432 for Postgres Service, port 3000 for grafana dashboards (userpass: admin / pigsty).

Installation

Install Pigsty on Linux Servers

Preparation

Prepare Environment for Serious Deployment

Configuration

Customize database clusters with Config Inventory

Administration

Manage your environment with Ansible Playbook

Modules

Pigsty consists of multiple modules. The PINE stack: PGSQL / INFRA / NODE / ETCD are REQUIRED for self-hosting Postgres RDS service.

PGSQL

PostgreSQL Cluster with HA, PITR, IaC, ACL, Monitoring, Pooling,…

INFRA

Nginx, Repo, DNS, NTP, Prometheus and Grafana stack for Observability

NODE

Enroll nodes into the desired state and monitor it, and VIP, HAProxy

ETCD

Reliable distributive consensus storage (DCS), empowering PGSQL HA

Pigsty also have some OPTIONAL "Bonus" modules, which works well with PostgreSQL, and brings extra value to your data infrastructure.

MINIO

S3 compatible object storage compatible, optional backup storage

REDIS

High-performance in-memory cache, optinal data structure server

DOCKER

Container runtime, optional for running stateless app and tools

FERRET

MongoDB wire-protocal compatible on PostgreSQL, optional middleware

FAQ