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

Kumar, Vallarapu Naga Avinash

  • 出版商: Packt Publishing
  • 出版日期: 2021-02-26
  • 售價: $1,350
  • 貴賓價: 9.5$1,283
  • 語言: 英文
  • 頁數: 344
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1838648135
  • ISBN-13: 9781838648138
  • 相關分類: PostgreSQLSQL資料庫
  • 立即出貨 (庫存=1)

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

商品描述

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


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


Book Description:

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.


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


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.

商品描述(中文翻譯)

深入了解為企業和生產數據庫構建可靠、可擴展和易於維護的數據庫解決方案。

主要特點:
- 使用 PostgreSQL 13 功能實現端到端的現代數據庫管理
- 使用獨特的基於配方的方法設計、管理和構建企業數據庫解決方案
- 解決在追求最佳數據庫性能時遇到的常見和不太常見的挑戰

書籍描述:
PostgreSQL 已成為市場上最先進的開源數據庫。本書採用逐步指導的方法,有效地引導您在生產環境中部署 PostgreSQL。

本書首先介紹了 PostgreSQL 及其架構。您將涵蓋在設計和管理數據庫時遇到的常見和不太常見的挑戰。接下來,本書專注於備份和恢復策略,以確保數據庫穩定並實現最佳性能。在整本書中,您將解決關鍵挑戰,例如維護可靠性、數據完整性、容錯環境、強大的功能集、可擴展性、一致性和身份驗證。隨著進一步的學習,您將了解如何管理 PostgreSQL 集群並探索高可用性的複寫功能。後面的章節將幫助您構建安全的 PostgreSQL 服務器,並涵蓋加密傳輸和靜態數據的配方。最後,您不僅將發現如何調整數據庫以實現最佳性能,還將了解如何監控和管理維護活動,以及在停機時間內執行 PostgreSQL 升級。

通過閱讀本書,您將熟悉 PostgreSQL 13 的基本功能,以構建企業關聯數據庫。

學到什麼:
- 瞭解在 Postgres 中的邏輯和物理備份
- 演示當今 PostgreSQL 可能的不同類型的複寫方法
- 設置提供無縫自動故障轉移的高可用性集群
- 通過身份驗證、授權和審計保護 PostgreSQL 加密
- 分析 PostgreSQL 服務器的實時和歷史活動
- 瞭解如何監控 Postgres 13 中的關鍵服務
- 管理 PostgreSQL 集群的維護活動和性能調優

本書適合數據庫架構師、數據庫開發人員和管理員,或任何希望熟悉 PostgreSQL 13 功能以規劃、管理和設計高效數據庫解決方案的人。預期讀者具有 PostgreSQL 數據庫和 SQL 語言的相關經驗。