For this chapter, you must have a PostgreSQL server with at least two CPUs and 2 GB RAM and access to download RPMs over the internet from the PGDG repository and from GitHub.
PostgreSQL 13 Cookbook
By :
PostgreSQL 13 Cookbook
By:
Overview of this book
PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments.
The book starts with an introduction to PostgreSQL and its architecture. You’ll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you’ll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you’ll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you’ll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime.
By the end of this book, you’ll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases.
Table of Contents (14 chapters)
Preface
Cluster Management Fundamentals
Free Chapter
Cluster Management Techniques
Backup and Recovery
Advanced Replication Techniques
High Availability and Automatic Failover
Connection Pooling and Load Balancing
Securing through Authentication
Logging and Analyzing PostgreSQL Servers
Critical Services Monitoring
Extensions and Performance Tuning
Upgrades and Patches
About Packt
Customer Reviews