#System Administration

Detailed instructions for upgrading PostgreSQL 17.6 to 18.1 for production environments with minimal downtime. Includes pg_upgrade, logical replication, rollback plan, and updated best practices for PostgreSQL 18 with Async I/O, Statistics Preservation, and new pg_upgrade --swap mode.

Duy TranDecember 23, 202515 min

Learn how to deploy PostgreSQL High Availability cluster with Patroni and etcd. Practical course from A-Z: installation, configuration, automatic failover, monitoring and production operations. 29 lessons + detailed labs.