Skip to content

Home

Jump to bottom
Vonng edited this page Feb 11, 2023 · 25 revisions

Battery-Included PostgreSQL, Free RDS PG Alternative

Latest Version: v2.0.0-b6 | Stable Version: v1.5.1 | Demo

Documentation: Github Pages | Wiki | Website | 中文站点

pigsty-banner

What is Pigsty?

  • Open Source RDS: Open-Source alternative to public cloud RDS.

    Full-Featured Open-Source Alternative to RDS PostgreSQL

    RDS

    If you can have a better RDS service with the price of EC2, Why use RDS at all?

  • Postgres Distribution: PostgreSQL, PostGIS, TimescaleDB, Citus, Redis/GP, United in One!

    PostgreSQL Kernel, Extensions, Peripherals, and Companion

    pigsty-distro

    PostGIS, TimescaleDB, Citus, and hundreds of extensions!

  • Infra Best Practice: Grafana, Prometheus, Loki, AlertManager, Docker, Battery-Included!

    Open Source Infrastructure Best Practice, Ship runtime with databases!

    pigsty-infra

    If you can have a better RDS service with the price of EC2, Why use RDS at all?

  • Database as Code Tool: Manage production-ready HA database clusters in a declartive way!

    GUI & CLI, Handling 70% of database administration work in minutes!

    INTERFACE

    Define clusters in a declarative manner and materialize them with idempotent playbooks

Check Architecture & Demo for details.

Why Pigsty?

  • High-Availability: Auto-Pilot Postgres with idempotent instances & services, self-healing from failures!

    High-Availability PostgreSQL Powered by Patroni & HAProxy

    pigsty-ha

    Self-healing on hardware failures: Failover impact on primary < 30s, Switchover impact < 1s

  • Ultimate Observability: Unparalleled monitoring system based on modern open-source best-practice!!

    Observability powered by Grafana, Prometheus & Loki

    DASHBOARD

    3K+ metrics on 30+ dashboards, Check http://demo.pigsty.cc for a live demo!

  • Database as Code: Declarative config with idempotent playbooks. WYSIWYG and GitOps made easy!

    Define & Create a HA PostgreSQL Cluster in 10 lines of Code

    pigsty-iac

    Create a 3-node HA PostgreSQL with 10 lines of config and one command!

  • IaaS Provisioning: Bare metal or VM, Cloud or On-Perm, One-Click provisioning with Vagrant/Terraform

    Pigsty 4-nodes sandbox on Local Vagrant VM or AWS EC2

    pigsty-sandbox

    Full-featured 4 nodes demo sandbox can be created using pre-configured vagrant & terraform templates.

  • Versatile Scenario: Monitor existing RDS, Run docker template apps, Toolset for data apps & vis/analysis.

    Docker Applications, Data Toolkits, Visualization Data Apps

    APP

    If your software requires a PostgreSQL, Pigsty may be the easiest way to get one.

  • Production Ready: Proven in large-scale production environment

    Overview Dashboards for a Huge Production Deployment

    OVERVIEW

    A real-world Pigsty production deployment with 240 nodes, 13kC / 100T, 500K TPS , 3+ years.

  • Cost Saving: Use RDS with the Pirce of EC2. Save 50% ~ 90%.

    Price Reference for EC2 / RDS Unit ($ per core · per month)
    Resource Node Price
    AWS EC2 C5D.METAL 96C 200G 11 ~ 14
    Aliyun ECS 2xMem Series Exclusive 28 ~ 38
    IDC Self-Hosting: Dell R730 64C 384G x PCI-E SSD 3.2TB 2.6
    IDC Self-Hosting: Dell R730 40C 64G (China Mobile) 3.6
    UCloud VPC 8C / 16G Exclusive 3.3
    ⬆️ EC2 / RDS⬇️ RDS Price
    Aliyun RDS PG 2x Mem 36 ~ 56
    AWS RDS PostgreSQL db.T2 (4x) / EBS 60
    AWS RDS PostgreSQL db.M5 (4x) / EBS 84
    AWS RDS PostgreSQL db.R6G (8x) / EBS 108
    AWS RDS PostgreSQL db.M5 24xlarge (96C 384G) 182
    Oracle Licenses 1300

    AWS Price Calculator: You can run RDS service with a dramatic cost reduction with EC2 or IDC.

  • Security: On-Perm Deployment, Self-signed CA, Full SSL Support, PITR with one-command.

    PITR with Pgbackrest 
    pg-backup                      # make a full/incr backup
pg-pitr "2022-11-08 10:58:48"  # pitr to specific timepoint
pg-restore 20221108-105325F_20221108-105938I # restore to specific backup

    Check Backup & PITR for details

Check FEATURES for detail.

About

Pigsty (/ˈpɪɡˌstaɪ/) is the abbreviation of "PostgreSQL In Great STYle."

Wiki: https://github.com/Vonng/pigsty/wiki

Official Site: https://pigsty.cc/en/ , https://pigsty.cc/zh/

WeChat Group: Search pigsty-cc to join the WeChat group.

Telegram: https://t.me/joinchat/gV9zfZraNPM3YjFh

Discord: https://discord.gg/wDzt5VyWEz

Author: Vonng (rh@vonng.com)

License: AGPL-3.0

Copyright 2018-2022 rh@vonng.com

Clone this wiki locally