Deploy
Deploy various type of PostgreSQL cluster!
- Identity Parameters: Introduces the identity parameters required to define a standard PostgreSQL HA cluster.
- Singleton Deployment: Defines a single instance PostgreSQL cluster.
- Primary-Replica Cluster: Defines a standard availability cluster with one primary & one replica.
- Sync-Standby: Define a highly consistent cluster with sync standby and RPO = 0.
- Quorum Commit: Defines a cluster with higher data consistency: most replicas return commits on the successful side.
- Offline Replica: Dedicated instances for hosting OLAP analysis, ETL, and interactive personal queries individually.
- Cascade Instance: Used to build cascade within a cluster for many replica scenarios (20+) to reduce primary pressure.
- Standby Cluster: Produces real-time online clones of existing clusters for offsite disaster recovery or delayed.
- Delayed Cluster: For responding to software/human failures such as mistaken table and database deletion, faster than PITR.
- Citus Deployment: Deploy Citus distributed database cluster.
- MatrixDB Deployment: Deploy Greenplum7/PostgreSQL12 compatible chronological data warehouse.
PGSQL Basic
Basic primary-replica postgres cluster setup
PGSQL Offline Replica
Offline replica, special replica for offline ETL, interactive queries
PGSQL Standby Replica
Standby replicas and quorum commit
PGSQL Delayed Replica
Delayed replica, replica for human/software errors, accidental db/table drop, etc…
PGSQL Standby Cluster
Use one cluster as physical backup for another cluster
Citus Deployment
Distributive extension citus deployment
MatrixDB Deployment
MatrixDB (equal to Greenplum 7+ Time-Series database) deployment
PGSQL File Hierarchy Structure
PostgreSQL File Hierarchy Structure
Last modified 2022-06-04: fii en docs batch 2 (61bf601)