# 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

---

Section pages:

- [Architecture](/docs/pgsql/arch/): PostgreSQL cluster architecture and concept
- [Configure](/docs/pgsql/config/): Describe and configure PostgreSQL clusters
- [Parameter](/docs/pgsql/param/): customize postgres cluster with 121 parameters
- [Administration](/docs/pgsql/admin/): run administrative tasks
- [Playbook](/docs/pgsql/playbook/): control primitives
- [Monitor](/docs/pgsql/monitor/): Monitor existing PostgreSQL or RDS
- [FAQ](/docs/pgsql/faq/): frequently asked questions
- [User Role](/docs/pgsql/user/): In this context, User refers to logical objects created by SQL CREATE USER / ROLE
- [Database](/docs/pgsql/db/): In this context, Database refers to the object created by SQL `CREATE DATABASE`.
- [Service](/docs/pgsql/service/): reliable service access via lb, proxy, pool
- [Auth / HBA](/docs/pgsql/hba/): Host-Based Authentication in Pigsty
- [Privileges](/docs/pgsql/acl/): Access Control with default roles and privileges
- [Dashboard](/docs/pgsql/dashboard/): check visualized information
- [Migration](/docs/pgsql/migration/): zero-downtime blue-green deployment
- [Backup](/docs/pgsql/backup/): Backup and point-in-time recovery
- [Kernel](/docs/pgsql/kernel/): Replace vanilla PostgreSQL with exotic kernel forks
- [Extension](/docs/pgsql/extension/): Harness the synergistic power of PostgreSQL extensions