Mastering PostgreSQL Administration & Scaling: Build, Optimize, and Automate Modern Databases for High Performance and Resilience

by Denning, Hollis
ISBN: 9798273172456
Availability:
  • Online Only
$24.38

Available Offers

Pickup at {0} Out of stock at {0} Check other stores
FREE -
Ship to Me
$3.99 -

Overview

PostgreSQL has become the backbone of modern data platforms-powering transactional systems, analytics engines, SaaS applications, financial systems, and distributed cloud services. Yet running PostgreSQL in production is no longer about managing a single server. It requires scaling, observability, automation, failover safety, backup integrity, and predictable resilience.

This book is a complete, practical, and deeply technical guide to building and operating production-grade PostgreSQL environments-from single-instance administration to fully automated high-availability clusters with self-healing, monitoring, and disaster recovery.

Designed for database administrators, DevOps engineers, SREs, platform teams, and backend developers, this book teaches not only how to run PostgreSQL, but how to trust it in real-world operational environments.

What You Will Learn
Foundations & Core Administration
  • PostgreSQL architecture, memory layout, WAL, background processes, and directory structure
  • Role management, access control, authentication, and security hardening
  • Configuration tuning, logging, and lifecycle administration
Performance, Query Optimization & Scaling
  • Understanding query planning, indexing strategies, and execution profiling
  • Improving joins, complex queries, and workload performance
  • Tuning memory, storage, I/O, autovacuum, and checkpoint behavior
High Availability & Automated Failover
  • Streaming replication and replication topology design
  • Patroni-based automated failover with Distributed Consensus (DCS)
  • HAProxy load balancing and PgBouncer connection pooling
  • Recovery safety, replica integrity, and split-brain avoidance
Infrastructure-as-Code & Automation
  • Provisioning repeatable environments with Terraform
  • Configuration management with Ansible roles and playbooks
  • Rolling upgrades, controlled switchover, and zero-downtime migration workflows
Monitoring, Backup & Disaster Recovery
  • Prometheus + Grafana observability for real-time performance insight
  • pgBackRest backups with full, incremental, WAL archiving, and PITR restore drills
  • Validating RPO/RTO objectives and failure-mode readiness
Full End-to-End Production Deployment

A complete, reproducible, capstone lab guides you through building a self-healing, observed, scaled PostgreSQL HA cluster with:

  • Automated failover
  • Secure routing layers
  • Continuous backup + PITR readiness
  • Load testing and failover validation under real workload pressure
Who This Book Is For
  • Database Administrators who want to run PostgreSQL with confidence
  • DevOps & SRE Engineers implementing resilient stateful services
  • Backend & Platform Engineers deploying mission-critical data workloads
  • Organizations migrating from proprietary databases to PostgreSQL

If your goal is to operate PostgreSQL as a reliable platform-not just a database-this book is for you.

No guesswork. No outdated patterns. No theory without implementation.

Master PostgreSQL not just to run it - but to trust it.
Build systems that are automated, resilient, observable, recoverable, and engineered for the real world.

  • Format: Trade Paperback
  • Author: Denning, Hollis
  • ISBN: 9798273172456
  • Condition: New
  • Dimensions: 11.00 x 0.88
  • Number Of Pages: 432
  • Publication Year: 2025
Language: English