Concept

Some concept about PostgreSQL

PostgreSQL ER Model

ER Model about PostgreSQL Database

PostgreSQL Identity

How to assign identity for postgres entities

PostgreSQL Architecture

Pigsty High Available Architecture

PostgreSQL User

Biz User are object created by SQL CREATE USER/ROLE

PostgreSQL Database

Database is an object create by SQL CREATE DATABASE

PostgreSQL Service

Service is an abstraction for database functionality & access

PostgreSQL Access

Access is about traffic routing, how to connect to the right service

PostgreSQL Auth

Authentication is about identity verification and block/allow list

PostgreSQL Role System

Pigsty default role system and ACL demands

PostgreSQL Privilege

There’s a battery-included ACL models

Last modified 2022-06-03: add scaffold for en docs (6a6eded)