PostgreSQL 13 Cookbook

Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions

Vallarapu Naga Avinash Kumar 지음

Packt(GCO Science) 2021년 02월 26일 출간

작품소개

책소개

Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases

▶What You Will Learn
-Understand logical and physical backups in Postgres
-Demonstrate the different types of replication methods possible with PostgreSQL today
-Set up a high availability cluster that provides seamless automatic failover for applications
-Secure a PostgreSQL encryption through authentication, authorization, and auditing
-Analyze the live and historic activity of a PostgreSQL server
-Understand how to monitor critical services in Postgres 13
-Manage maintenance activities and performance tuning of a PostgreSQL cluster

▶Key Features
-Implement PostgreSQL 13 features to perform end-to-end modern database management
-Design, manage, and build enterprise database solutions using a unique recipe-based approach
-Solve common and not-so-common challenges faced while working to achieve optimal database performance

▶Who This Book Is For
This PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design efficient database solutions. Prior experience with the PostgreSQL database and SQL language is expected.

목차

▶TABLE of CONTENTS
-Chapter 1: Cluster Management Fundamentals
-Chapter 2: Cluster Management Techniques
-Chapter 3: Backup and Recovery
-Chapter 4: Advanced Replication Techniques
-Chapter 5: High Availability and Automatic Failover
-Chapter 6: Connection Pooling and Load Balancing
-Chapter 7: Securing through Authentication
-Chapter 8: Logging and Analyzing PostgreSQL Servers
-Chapter 9: Critical Services Monitoring
-Chapter 10: Extensions and Performance Tuning
-Chapter 11: Upgrades and Patches

책 속으로

▶What this book covers
- Chapter 1, Cluster Management Fundamentals, starts by showing how to install PostgreSQL 13 and initializing a data directory. We will then discuss pg_ctl and how it can be used to start and stop a PostgreSQL cluster.

- Chapter 2, Cluster Management Techniques, helps you get familiar with some of the important routine tasks in PostgreSQL.

- Chapter 3, Backup and Recovery, shows you several methods available to back up and restore a PostgreSQL database.

- Chapter 4, Advanced Replication Techniques, teaches you how to configure both streaming and logical replication, and you'll learn about some more crucial tasks in a production database environment.

- Chapter 5, High Availability and Automatic Failover, discusses one of the most heavily adopted open source high-availability tools available, called Patroni. It can be used to set up automatic failover. We shall learn how it can be configured and will also discuss the advantages and disadvantages of using it for high availability.

- Chapter 6, Connection Pooling and Load Balancing, discusses pgBouncer, which is a widely implemented, lightweight external pooler.

- Chapter 7, Securing through Authentication, teaches you how to secure PostgreSQL encryption through authentication, authorization, and auditing. You will also see how to encrypt connections over the wire and also at rest using SSL. We will also look at some extensions for performing auditing in PostgreSQL

- Chapter 8, Logging and Analyzing PostgreSQL Servers, has been designed to let admins know of the available options in PostgreSQL to enable the logging of certain important activities and to help admins/developers get familiar with some views, extensions, and tools to analyze live and historic activity in Postgres catalogs and log files.

- Chapter 9, Critical Services Monitoring, shows how we can set up the monitoring of servers using Grafana and Prometheus.

- Chapter 10, Extensions and Performance Tuning, shows us what extens

출판사 서평

▶ Preface
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.

작가정보

저자(글) Vallarapu Naga Avinash Kumar

Vallarapu Naga Avinash Kumar is currently working as a PostgreSQL Tech Lead at Percona. Before joining Percona, Avi worked as a Database Architect at OpenSCG for 2 Years and as a DBA Lead at Dell for 10 Years in Database technologies such as PostgreSQL, Oracle, MySQL and MongoDB. He has given several talks and trainings on PostgreSQL. He has good experience in performing Architectural Health Checks, Performance Tuning and Migrations to PostgreSQL Environments. He has also co-authored a book - Beginning PostgreSQL on Cloud that gives an introduction to building PostgreSQL on AWS, Microsoft Azure, Google Cloud and Rackspace cloud platforms. He has been a speaker at several PostgreSQL conferences in North America, Europe and Asia every year and continuing to blog on PostgreSQL.