Who Let The Dogs Out 🐾Oct 19, 2023

PostgreSQL in Great STYle, Battery-Included Free RDS Alternative

#docker #redis #ansible #distribution #postgres #grafana #prometheus #postgis #etcd #haproxy #minio #high_availability #rds #citus #observability #database_as_code #patroni #dbaas #timescaledb #opensource_alternative

Free RDS for PostgreSQL

- Battery-Included PostgreSQL distribution with 150+ optional extensions.
- Run on bare OS without container: EL7/8/9, Ubuntu 20/22 and Debian 11/12.
- Incredible observability powered by Prometheus & Grafana stack. Demo & Gallery.
- Self-healing HA PGSQL cluster, powered by patroni, haproxy, etcd. auto-tuned.
- Auto-Configured PITR, powered by pgBackRest and optional MinIO repo (or S3/FS).
- Declarative API, Database-as-Code implemented with Ansible playbooks: SOP.
- Handy IaC Templates, provisioning Infra with Terraform and try sandbox with Vagrant.
- Pre-pack stable versions, create local repos and install without Internet access.

https://github.com/Vonng/pigsty

GitHub - Vonng/pigsty: Battery-Included PostgreSQL Distro as a Free RDS Alternative

Battery-Included PostgreSQL Distro as a Free RDS Alternative - Vonng/pigsty

GitHub
Show threadWho Let The Dogs Out 🐾3d ago

Pigsty scales from laptop to datacenter. Enterprise-grade. Developer-friendly. Get Started with the latest v4.2.2:

```sh
curl -fsSL https://repo.pigsty.io/get | bash -s v4.2.2
```

**Features**

- Extensible: 464+ PG Extensions & 12 PG Kernels available, Packed for 14 Linux Platforms, Battery-Included.
- Reliable: Self-healing HA clusters with pre-configured PITR and built-in ACL, CA & SSL secure best practice.
- Observable: SOTA monitoring for PG / Infra / Node based on the Victoria & Grafana stack: Demo & Gallery.
- Scalable: Auto-routed & pooled customizable database Services Access with haproxy, pgbouncer, and VIP.
- Maintainable: One-Cmd Deploy, Admin SOP, Auto-Tune, Local Repo, IaC and Vagrant / Terraform support.
- Composable: Bonus Modules such as Redis, MinIO, Etcd, Docker, DuckDB, FerretDB, Supabase, & More.
- Controllable: Self-sufficient Infra Closure, Cloud Neutral FOSS. Run on bare Linux without Docker & K8S.
- Affordable: Self-Hosting like a Pro, without the cost of RDS.

Show threadWho Let The Dogs Out 🐾

Pigsty uses a modular design: you can use one or all, with best-of-breed products integrated as a platform.

OPGSQL Self-healing PostgreSQL HA cluster powered by Patroni, Pgbouncer, PgBackrest & HAProxy

INFRA Nginx, Local Repo, DNSMasq, and the entire Victoria & Grafana observability stack.

NODE Init node name, repo, pkg, NTP, ssh, admin, tune, expose services, collect logs & metrics.

ETCD Etcd cluster is used as a reliable distributed configuration store by PostgreSQL HA agents.

You can compose them freely in a declarative manner. INFRA & NODE will suffice for host monitoring. ETCD and PGSQL are used for HA PG clusters; installing them on multiple nodes automatically forms HA clusters.

The default [deploy.yml](https://github.com/pgsty/pigsty/blob/main/deploy.yml) playbook will deploy INFRA, NODE, ETCD & PGSQL on the current node. This gives you an out-of-the-box PostgreSQL singleton instance (admin_ip:5432) with everything ready.

#pigsty #postgres

Apr 10 at 5:55pmWeb
Show threadWho Let The Dogs Out 🐾3d ago

The node can be used as an admin controller to deploy & monitor more nodes & clusters. For example, you can install these 6 OPTIONAL extra modules for advanced use cases:

MinIO S3-compatible object storage service; used as an optional central backup server for PGSQL.

Redis Deploy Redis servers in standalone master-replica, sentinel, and native cluster mode.

Ferret Native support for FerretDB — adding MongoDB wire protocol compatibility to Postgres!

Docker Launch optional docker daemons to run other stateless parts besides Pigsty RDS.

Juice JuiceFS can mount S3/MinIO, and even PostgreSQL as a filesystem shared by multi users.

Vibe Vibe coding environment with VS Code Server, JupyterLab, Node.js, and Claude Code.

Of course, you can deploy different kinds of HA PostgreSQL clusters on multiple nodes, as much as you want.

#minio #redis #ferret #docker #juicefs #postgres #rds #citus #patroni