PostgreSQL 10 Administration Cookbook: Over 165 effective recipes for database management and maintenance in PostgreSQL 10

A practical guide to administer, monitor and replicate your PostgreSQL 10 database

Key Features

• Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently
• Monitor, tune, secure and protect your database for optimal performance
• A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL 10 administration with ease

Book Description

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 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.

Throughout this book, you will be introduced to these new features such as logical replication, native table partitioning, additional query parallelism, and much more. You will learn how to tackle a variety of problems that are basically the pain points for any database administrator - from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication.

By the end of this book, you will know everything you need to know to be the go-to PostgreSQL expert in your organization.

What you will learn

• Get to grips with the newly released PostgreSQL 10 features to improve database performance and reliability
• Manage open source PostgreSQL versions 10 on various platforms.
• Explore best practices for planning and designing live databases
• Select and implement robust backup and recovery techniques in PostgreSQL 10
• Explore concise and clear guidance on replication and high availability
• Discover advanced technical tips for experienced users

Who This Book Is For

This book is for database administrators, data architects, developers, or anyone with an interest in planning for, or running, live production databases using PostgreSQL. It is most suited to those looking for hands-on solutions to any problem associated with PostgreSQL administration.

Table of Contents

1. First Steps
2. Exploring the Database
3. Configuration
4. Server Control
5. Tables and Data
6. Security
7. Database Administration
8. Monitoring and Diagnosis
9. Regular Maintenance
10. Performance and Concurrency
11. Backup and Recovery
12. Replication and Upgrades

《實用指南：管理、監控和複製您的 PostgreSQL 10 資料庫》

關鍵特點：
- 瞭解 PostgreSQL 10 的功能，以更有效地管理您的資料庫
- 監控、調整、保護和提升資料庫的效能
- 透過逐步、基於配方的指南，輕鬆解決 PostgreSQL 10 管理中的任何問題

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

在本書中，您將瞭解到諸如邏輯複製、原生表格分區、額外的查詢並行處理等新功能。您將學習如何應對各種問題，這些問題基本上是任何資料庫管理員的痛點 - 從建立表格到管理視圖，從提升效能到保護資料庫。更重要的是，本書特別關注監控角色、備份和恢復 PostgreSQL 10 資料庫，確保高可用性、並行處理和複製。

通過閱讀本書，您將全面掌握成為組織中 PostgreSQL 專家所需的一切知識。

您將學到：
- 瞭解新發佈的 PostgreSQL 10 功能，以提升資料庫效能和可靠性
- 在不同平台上管理開源 PostgreSQL 10 版本
- 探索規劃和設計實時資料庫的最佳實踐
- 選擇並實施堅固的 PostgreSQL 10 備份和恢復技術
- 瞭解有關複製和高可用性的簡明明確指南
- 發現經驗豐富用戶的高級技術提示

本書適合對使用 PostgreSQL 計劃或運行實時生產資料庫的資料庫管理員、資料架構師、開發人員或任何對此感興趣的人。對於那些尋找實用解決方案來解決與 PostgreSQL 管理相關的任何問題的人來說，本書尤其適合。

目錄：
1. 初步步驟
2. 探索資料庫
3. 設定
4. 伺服器控制
5. 表格和資料
6. 安全性
7. 資料庫管理
8. 監控和診斷
9. 定期維護
10. 效能和並行處理
11. 備份和恢復
12. 複製和升級