PostgreSQL Configuration: Best Practices for Performance and Security

Shaik, Baji

  • 出版商: Apress
  • 出版日期: 2020-03-17
  • 售價: $1,400
  • 貴賓價: 9.5$1,330
  • 語言: 英文
  • 頁數: 226
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 148425662X
  • ISBN-13: 9781484256626
  • 相關分類: PostgreSQLSQL資訊安全
  • 立即出貨 (庫存 < 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 社群聚會,並維護自己的技術部落格,喜歡與社群分享知識。他是《Beginning PostgreSQL on the Cloud》(於2018年3月發行)的合著者。