PostgreSQL 14 Administration Cookbook: Over 175 proven recipes for database administrators to manage enterprise databases effectively

Riggs, Simon, Ciolli, Gianni

  • 出版商: Packt Publishing
  • 出版日期: 2022-03-31
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 608
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1803248971
  • ISBN-13: 9781803248974
  • 相關分類: PostgreSQLSQL資料庫
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenance

Key Features

- Troubleshoot and tackle any administration and management problems in PostgreSQL 14
- Find expert techniques for monitoring, fine-tuning, and securing your database
- Adopt efficient replication for high availability with PostgreSQL 14

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 14 allows you to scale up your PostgreSQL infrastructure. With this book, you'll take a step-by-step, recipe-based approach to effective PostgreSQL administration.

This book will get you up and running with all the latest features of PostgreSQL 14 while helping you explore the entire database ecosystem. You'll learn how to tackle a variety of problems and pain points you may face as a database administrator such as creating tables, managing views, improving performance, and securing your database. As you make progress, the book will draw attention to important topics such as monitoring roles, validating backups, regular maintenance, and recovery of your PostgreSQL 14 database. This will help you understand roles, ensuring high availability, concurrency, and replication. Along with updated recipes, this book touches upon important areas like using generated columns, TOAST compression, PostgreSQL on the cloud, and much more.

By the end of this PostgreSQL book, you'll have gained the knowledge you need to manage your PostgreSQL 14 database efficiently, both in the cloud and on-premise.

What you will learn

- Plan, manage, and maintain PostgreSQL databases in production
- Work with the newly introduced features of PostgreSQL 14
- Use pgAdmin or OmniDB to perform database administrator (DBA) tasks
- Use psql to write accurate and repeatable scripts
- Understand how to tackle real-world data issues with the help of examples
- Select and implement robust backup and recovery techniques in PostgreSQL 14
- Deploy best practices for planning and designing live databases

Who this book is for

This Postgres 14 book is for database administrators, data architects, database developers, and anyone with an interest in planning and running live production databases using PostgreSQL 14. Those looking for hands-on solutions to any problem associated with PostgreSQL 14 administration will also find this book useful. Some experience with handling PostgreSQL databases will help you to make the most out of this book, however, it is a useful resource even if you are just beginning your Postgres journey.

商品描述(中文翻譯)

管理、監控和複製您的 PostgreSQL 14 資料庫,以實現高效的資料庫管理和維護

主要特點

- 解決和應對 PostgreSQL 14 的任何管理和維護問題

- 尋找專家技巧,以監控、調優和保護您的資料庫

- 使用 PostgreSQL 14 實現高可用性的有效複製

書籍描述

PostgreSQL 是一個功能強大的開源資料庫管理系統,以其高性能和穩定性而聞名。PostgreSQL 14 在其工具箱中擁有許多新功能,讓您能夠擴展 PostgreSQL 基礎架構。通過本書,您將以逐步、基於配方的方式進行有效的 PostgreSQL 管理。

本書將讓您熟悉 PostgreSQL 14 的最新功能,同時幫助您探索整個資料庫生態系統。您將學習如何應對作為資料庫管理員可能面臨的各種問題和痛點,例如創建表格、管理視圖、提高性能和保護資料庫。隨著您的進展,本書將引起您對重要主題的關注,例如監控角色、驗證備份、定期維護和恢復 PostgreSQL 14 資料庫。這將幫助您了解角色、確保高可用性、並進行並行處理和複製。除了更新的配方,本書還涉及重要領域,如使用生成的列、TOAST 壓縮、雲上的 PostgreSQL 等等。

通過閱讀本書,您將獲得管理雲端和本地 PostgreSQL 14 資料庫的知識。

您將學到什麼

- 計劃、管理和維護生產環境中的 PostgreSQL 資料庫

- 使用 PostgreSQL 14 的新功能

- 使用 pgAdmin 或 OmniDB 執行資料庫管理員 (DBA) 任務

- 使用 psql 編寫準確且可重複執行的腳本

- 通過示例了解如何應對現實世界的資料問題

- 選擇並實施堅固的 PostgreSQL 14 備份和恢復技術

- 部署規劃和設計實時資料庫的最佳實踐

本書適合對象

本書適合資料庫管理員、資料架構師、資料庫開發人員以及任何有興趣使用 PostgreSQL 14 計劃和運行實時生產資料庫的人。對於尋找 PostgreSQL 14 管理相關問題的實用解決方案的人也會發現本書很有用。雖然具有處理 PostgreSQL 資料庫的經驗將有助於您充分利用本書,但即使您剛開始接觸 PostgreSQL,本書也是一個有用的資源。

目錄大綱

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

目錄大綱(中文翻譯)

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