{"product_id":"enterprise-postgresql-high-availability-scaling-upgrades-and-performance-9798868833342","title":"Enterprise PostgreSQL: High Availability, Scaling, Upgrades, and Performance","description":"\u003cp\u003ePostgreSQL has become a leading platform for mission-critical applications, but successful production deployments require far more than basic database administration. This book provides a practical guide to upgrading, scaling, protecting, integrating, and optimizing PostgreSQL in modern enterprise environments.\u003c\/p\u003e\u003cp\u003eYou will learn how to perform PostgreSQL minor and major version upgrades, design highly available architectures, implement switchover and failover strategies, configure logical replication, and deploy resilient Patroni clusters. The book also explores distributed PostgreSQL with Citus for horizontal scalability, Change Data Capture (CDC) pipelines using PostgreSQL, Kafka, Debezium, and Docker, and practical performance tuning for production workloads.\u003c\/p\u003e\u003cp\u003eEach chapter combines architectural concepts with hands-on implementation, step-by-step configuration guidance, troubleshooting techniques, best practices, and real-world scenarios, helping you move from routine PostgreSQL administration to managing highly available, scalable, and performance-optimized production environments.\u003c\/p\u003e\u003cp\u003eWhat You Will Learn\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003ePerform PostgreSQL minor and major version upgrades with minimal downtime\u003c\/li\u003e\n\u003cli\u003eDesign and implement high-availability PostgreSQL architectures\u003c\/li\u003e\n\u003cli\u003eConfigure switchover, failover, and logical replication solutions\u003c\/li\u003e\n\u003cli\u003eDeploy and manage PostgreSQL clusters using Patroni\u003c\/li\u003e\n\u003cli\u003eImplement distributed PostgreSQL architectures with Citus for horizontal scalability\u003c\/li\u003e\n\u003cli\u003eBuild Change Data Capture (CDC) pipelines using PostgreSQL, Kafka, Debezium, and Docker\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and optimize PostgreSQL performance for production workloads\u003c\/li\u003e\n\u003cli\u003eApply best practices for managing and maintaining enterprise PostgreSQL environments\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eWho This Book is For\u003c\/p\u003e\u003cp\u003eAdvanced PostgreSQL users, including PostgreSQL administrators, database architects, developers, consultants, migration and high availability engineers, and performance tuning specialists. \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 11\/18\/2026\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9798868833342\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 373","brand":"Y. V. Ravi Kumar,Sambaiah Sammeta,Jeyaram Ayyalusamy","offers":[{"title":"Default Title","offer_id":53459133431989,"sku":"9798868833342","price":50.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/files\/9798868833342.jpg?v=1791297759","url":"https:\/\/pastforward.org\/products\/enterprise-postgresql-high-availability-scaling-upgrades-and-performance-9798868833342","provider":"Past Forward","version":"1.0","type":"link"}