Reliable Infra: Rock-Solid and Secure

Towering peaks, bedrock solid, standing firm at any summit!

High-Availability: Reliable PostgreSQL RDS

Pigsty delivers PG HA solutions which follows the industry best practice

Adjustable RTO and RPO, balancing trade-offs for specific scenarios.

Primary failover metrics: RTO ≈ 30 seconds (adjustable)
async commit mode: RPO < 1MB, crit mode: RPO = 0 (adjustable)
Replica failure / switchover: RTO ≈ 0 seconds

Service	Port	Description
primary	5433	Production read-write, connects to primary connection pool
replica	5434	Production read-only, connects to replica connection pool
default	5436	Administration, ETL writes, direct access to primary
offline	5438	OLAP, ETL, individual users, interactive queries

Self-Healing: Adaptive service failover

Self-healing arch with transparent topology, multi-writer experience

Flexible service access, automatically traffic routing, DevOps sleep well

Industry HA best practices: Patroni, Etcd, HAProxy, VIP Manager
4 default services: primary, replica, offline, default, with read-write splitting
Route Read/Write traffic based on health checks, without human intervention
Flexible access methods: IP, Connection Pools, L2 VIP, L4 LB, SD, etc.

pg-pitr                               # Recover to WAL archive endpoint
pg-pitr -i                            # Recover to most recent backup point
pg-pitr --time=2022-12-30 14:44:44+08 # Recover to specific time point
pg-pitr --name=my-restore-point       # Recover to named restore point
pg-pitr --lsn=0/7C82CB8 -X            # Recover immediately before LSN
pg-pitr --xid=1234567 -X -P           # Recover before specified XID
pg-pitr --backup=latest               # Recover to latest backup set
pg-pitr --backup=20221108-105325      # Recover to specific backup set

PITR Protection: Pre-configured Backup & Archives

Pre-configures physical backups and enables WAL archiving by default

Local fs or remote S3/MinIO, mature disaster recovery solutions on demand

Industry backup best practices: pgBackRest + MinIO / Local Disk / S3
Protection against software defects and human errors (Accidental deletion)
One-command backup and restore, flexible backup strategies with crontab
In-place concurrent incremental PITR, fast recovery with quick retry options

Infra Closure: No external dependencies

A complete infra closure for PostgreSQL RDS, requiring no external deps.

Local repo snapshoting all packages - run locally until the end of time.

Observability infrastructure: Prometheus / Grafana
Load balancing and reverse proxy: Nginx / HAProxy
Configuration and object storage: Etcd / MinIO
Critical services DNS and NTP: DNSMasq / Chronyd

Role Name	Description
dbrole_readonly	Role: Global read-only access
dbrole_readwrite	Role: Global read-write access
dbrole_admin	Role: Admin/object creation
dbrole_offline	Role: Limited read-only access
postgres	System superuser
replicator	System replication user
dbuser_dba	PostgreSQL admin user
dbuser_monitor	PostgreSQL monitoring user