PostgreSQL 15 Cookbook (ePub)

This book is intended for PostgreSQL database administrators seeking a comprehensive guide to managing their databases. It provides 100-ready solutions to common database management challenges and offers a complete guide to administering and troubleshooting databases using the latest version of PostgreSQL 15.

The book covers all aspects of database administration, starting with cloud provisioning and migration. It also covers replication, transaction logs, partitioning, sharding, auditing, real-time monitoring, backup, recovery, and error debugging. The solutions are presented in a clear, easy-to-follow format and use a real database named 'adventureworks' for on-the-job practice.

Throughout the book, readers will learn how to use tools such as pglogical, pgloader, WAL, repmgr, Patroni, HAProxy, PgBouncer, pgBackRest, pgAudit, and Prometheus, gaining valuable experience and expertise in managing their databases. With a focus on practical solutions and real-world scenarios, the PostgreSQL 15 Cookbook is an essential resource for any PostgreSQL database administrator, whether they are just starting or are seasoned professionals.

Key Learnings

• Streamline PostgreSQL databases with cloud provisioning and migration techniques
• Optimize performance and scalability through effective replication, partitioning, and sharding
• Safeguard your databases with robust auditing, backup, and recovery strategies
• Monitor databases in real-time with powerful tools like pgAudit, Prometheus, and Patroni
• Troubleshoot errors and debug your databases with expert techniques and best practices
• Boost productivity and efficiency with advanced tools like pglogical, pgloader, and HAProxy.