PostgreSQL 11 Administration Cookbook

PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.

The book will introduce you to new features such as logical replication, native table partitioning, additional query parallelism, and much more to help you to understand and control, crash recovery and plan backups. You will learn how to tackle a variety of problems and pain points for any database administrator such as creating tables, managing views, improving performance, and securing your database. As you make steady progress, the book will draw attention to important topics such as monitoring roles, backup, and recovery of your PostgreSQL 11 database to help you understand roles and produce a summary of log files, ensuring high availability, concurrency, and replication.

By the end of this book, you will have the necessary knowledge to manage your PostgreSQL 11 database efficiently.

PostgreSQL 是一個功能強大且開源的資料庫管理系統，以其高效能和穩定性而聞名。PostgreSQL 11 具備許多新功能，讓您能夠擴展 PostgreSQL 基礎架構。本書以逐步、基於配方的方式介紹有效的 PostgreSQL 管理。

本書將介紹一些新功能，例如邏輯複寫、原生表格分割、額外的查詢並行處理等，以幫助您了解和控制崩潰恢復和計劃備份。您將學習如何應對各種問題和資料庫管理員的痛點，例如建立表格、管理視圖、提升效能和保護資料庫。隨著您的進展，本書將引起您對重要主題的關注，例如監控角色、備份和恢復 PostgreSQL 11 資料庫，以幫助您了解角色並產生日誌檔案摘要，確保高可用性、並行處理和複寫。

通過閱讀本書，您將具備管理 PostgreSQL 11 資料庫的必要知識。