Mastering PostgreSQL High Availability

Explore the history and evolution of PostgreSQL from its Postgres origins at Berkeley to the current open source, SQL-enabled, highly available database, including architecture, security, and replication.

Learn how to install PostgreSQL on Linux, decide version and location, and explore deployment options such as Big Animal, cloud native Postgres, native packages, and source code installations.

Install Postgres 18 on Linux by adding repository and disabling older module. Initialize database, enable and start service, connect with psql while configuring port 5432 and firewall.

Explore the PostgreSQL system architecture, including postmaster and background processes, shared memory, buffers, write-ahead log (wal), archiver, and checkpoint mechanisms for high availability.

Explore PostgreSQL replication options, including log shipping, streaming and logical replication, with synchronous or asynchronous modes, plus cascading and bidirectional setups for high availability.

Explain streaming replication in PostgreSQL, compare asynchronous and synchronous configurations, discuss data loss risks, replication lag, and trade-offs between durability and performance.

Explore cascading replication in PostgreSQL, where a standby can serve as a source for other replicas to offload the primary and reduce bandwidth, noting it is asynchronous with lag.

Configure streaming replication in PostgreSQL by understanding parameters and asynchronous versus synchronous commits. Manage replicas with wall keep size, replication slots, and recovery, hot standby, and logical replication.

Learn how to configure a PostgreSQL replication setup with a primary and a secondary server, establish passwordless SSH between hosts, and align network settings for replication.

Demonstrates setting up a two-server PostgreSQL high-availability environment with passwordless SSH and replication manager, and explains streaming replication, base backups, and primary-standby configuration on Linux with PostgreSQL 17.