Features

🐘 Database engine

• PostgreSQL 17 as the default major version; 13 / 14 / 15 / 16 also supported
• 340+ precompiled extensions covering OLTP, OLAP, time-series, geo, vector, full-text, graph, audit
• Multiple kernels available: native PostgreSQL, Citus (distributed), PolarDB, Greenplum, MSSQL-compatibility mode

🔋 High availability

• Patroni + etcd — automatic failover, typically completed within seconds
• HAProxy — routes read/write traffic; read replicas join the pool automatically
• L2 VIP / DNS — multiple ways to expose the service address
• See HA architecture

💾 Backup & recovery

• pgBackRest — full / differential / incremental backups
• PITR — point-in-time recovery accurate to the transaction
• Cold backups to local disk, MinIO or any S3-compatible store
• See backup guide

📊 Observability

• Prometheus + VictoriaMetrics — metrics collection
• Grafana — 30+ preconfigured dashboards
• Loki — log aggregation
• pg_exporter — exposes 600+ PostgreSQL metrics
• See monitoring guide

🧩 Modular architecture

Mix and match:

• PGSQL — PostgreSQL core
• INFRA — monitoring / DNS / NTP / package repository
• NODE — host initialization, VIP, HAProxy
• ETCD — DCS
• MINIO — S3-compatible object storage
• REDIS — standalone / sentinel / cluster
• FERRET — MongoDB wire-protocol compatibility
• DOCKER — container runtime
• More: JUICE, VIBE, PILOT

🛡️ Security

• Self-signed certificate authority and TLS
• Enforced password complexity
• Row-level security and audit logging
• Least-privilege model
• See security hardening

⚡ IaC and bulk operations

• A single declarative YAML file describes the whole infrastructure
• Ansible playbooks cover install, scale-out, switchover, backup, restore — the full lifecycle
• See IaC concept

🌐 Deployment coverage

• EL 7/8/9, Debian 12, Ubuntu 22/24, openEuler, Kylin, UOS, …
• Offline-capable
• Single-node to thousands of nodes
• On-prem, public cloud, hybrid, edge