This comprehensive guide explains PostgreSQL streaming replication concepts, required environment, primary and standby configuration commands, verification queries, failover procedures, and production best‑practice recommendations, enabling you to build a reliable high‑availability database cluster.
This article explains how to safeguard PostgreSQL against data loss by using event triggers to block risky DDL operations, implementing a recycle‑bin approach for deleted objects, and applying delayed streaming replication or physical backup techniques for effective data recovery.
This tutorial walks through setting up PostgreSQL 12 master‑slave streaming replication and continuous WAL archiving, covering password‑less SSH, master and standby configuration, base backup, recovery settings, and verification steps to achieve a high‑availability database cluster.
This guide explains how to create a high‑availability PostgreSQL cluster on two hosts using streaming replication, automatic failover and failback, dual virtual IPs, heartbeat monitoring, and stress testing, with full configuration scripts and practical test results.
