PostgreSQL Configuration: Best Practices for Performance and Security
暫譯: PostgreSQL 配置：性能與安全的最佳實踐

Shaik, Baji

PostgreSQL Configuration: Best Practices for Performance and Security
  • 出版商: Apress
  • 出版日期: 2020-03-17
  • 定價: $1,400
  • 售價: 8.0 折 $1,120
  • 語言: 英文
  • 頁數: 226
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 148425662X
  • ISBN-13: 9781484256626
  • 相關分類: PostgreSQL、SQL、資訊安全

    • 立即出貨 (庫存 < 3)

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

相關主題

商品描述

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in PostgreSQL.

Every system containing valuable data needs to be backed-up regularly. PostgreSQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner.

What You Will Learn

  • Configure PostgreSQL for performance
  • Monitor and maintain PostgreSQL instances
  • Implement a backup strategy for your data
  • Resolve errors faced while using PostgreSQL

Who This Book Is For

Readers with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment.

商品描述(中文翻譯)

取得配置和管理 PostgreSQL 資料庫所需的所有技能。在本書中，您將首先安裝和配置 PostgreSQL，重點放在安裝前的系統級參數設置。您還將查看關鍵的安裝後步驟，以避免未來出現問題。PostgreSQL 的基本配置是針對兼容性而非性能進行調整的。考慮到這一點，您將根據您的環境和應用行為微調 PostgreSQL 參數。接著，您將獲得改善資料庫監控和維護的建議，然後學習如何在 PostgreSQL 中處理敏感數據的資料庫安全性。

每個包含有價值數據的系統都需要定期備份。PostgreSQL 遵循簡單的備份程序，並提供基本的方法來備份您的數據。您將了解這些方法，並根據您的環境選擇合適的一種。以有限資源運行應用程序可能會很棘手。為了實現這一點，您將為 PostgreSQL 實例實施一個連接到其他資料庫的連接池機制。最後，您將查看在使用 PostgreSQL 時遇到的一些基本錯誤，並學習以最快的方式解決它們。

您將學到什麼


  • 為性能配置 PostgreSQL

  • 監控和維護 PostgreSQL 實例

  • 為您的數據實施備份策略

  • 解決使用 PostgreSQL 時遇到的錯誤

本書適合誰

對 PostgreSQL 有基本知識的讀者，希望根據其環境實施關鍵解決方案。

作者簡介

Baji Shaik is a database administrator and developer. He was introduced to databases in 2011 and over the years, has worked with Oracle, PostgreSQL, Postgres Advance Server, RedShift, and Greenplum. He has a wide range of expertise and experience in SQL/NoSQL databases such as Cassandra and DynamoDB. He is a database migration expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to AWS Cloud using multiple AWS services. Baji has organized a number of PostgreSQL meet-ups and maintains his own technical blog, where he likes to share his knowledge with the community. He co-authored Beginning PostgreSQL on the Cloud, released in March 2018.

作者簡介(中文翻譯)

Baji Shaik 是一位資料庫管理員和開發者。他於 2011 年接觸資料庫，並在這些年中，與 Oracle、PostgreSQL、Postgres Advance Server、RedShift 和 Greenplum 等資料庫系統合作。他在 SQL/NoSQL 資料庫方面擁有廣泛的專業知識和經驗，例如 Cassandra 和 DynamoDB。他是一位資料庫遷移專家，並開發了許多成功的資料庫解決方案，以應對將資料庫從本地遷移到 AWS Cloud 的挑戰性商業需求，使用了多種 AWS 服務。Baji 組織了多場 PostgreSQL 會議，並維護自己的技術部落格，喜歡與社群分享他的知識。他共同撰寫了於 2018 年 3 月發行的 Beginning PostgreSQL on the Cloud。

類似商品