PostgreSQL
The most advanced open source relational database in the world!
Concept
Architecture
PostgreSQL cluster architecture and concept
Service
Reliable service access via lb, proxy, pool
Database
Define, create, and manage business databases
User Role
Define, create, and manage users and roles
Auth / HBA
Host-Based Authentication in Pigsty
Privileges
Access Control with default roles and privileges
Administration
Kernel
Replace vanilla PostgreSQL with exotic kernel forks
Extension
Harness the synergistic power of PostgreSQL extensions
Configure
Describe and configure PostgreSQL clusters
Parameter
Customize postgres cluster with 120 parameters
Administration
Run administrative tasks on PostgreSQL clusters
Playbook
Control primitives with Ansible playbooks
Backup & PITR
Backup and point-in-time recovery
Migration
Zero-downtime blue-green deployment
Monitor
Monitor existing PostgreSQL or RDS
Dashboard
Visualized information with Grafana dashboards