PostgreSQL Cookbook
暫譯: PostgreSQL 食譜

Chitij Chauhan

  • 出版商: Packt Publishing
  • 出版日期: 2015-01-30
  • 售價: $1,880
  • 貴賓價: 9.5$1,786
  • 語言: 英文
  • 頁數: 286
  • 裝訂: Paperback
  • ISBN: 1783555335
  • ISBN-13: 9781783555338
  • 相關分類: PostgreSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL

About This Book

  • Implement a highly available PostgreSQL database server and perform administrative and development functions with PostgreSQL
  • Perform database operations in PostgreSQL using Perl and Python
  • Step-by-step recipes focusing on providing real-world Postgresql solutions

Who This Book Is For

If you are a system administrator, database administrator, architect, developer, or anyone with an interest in planning, managing, and designing database solutions using PostgreSQL, this is the book for you. This book is suited for you if you have some prior experience with any relational database or with the SQL language.

What You Will Learn

  • Perform regular maintenance tasks to keep your database steady and achieve optimal performance
  • Design and implement various high availability and replication features to provide redundancy, fault tolerance, and failover
  • Diagnose and troubleshoot CPU, memory, and I/O related database performance issues
  • Perform database operations using languages such as Perl and Python
  • Discover the different backup and recovery strategies that can be implemented in PostgreSQL
  • Implement connection pooling methods to achieve load balancing

In Detail

PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).

With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and how to utilize them to solve real-world problems. With the aid of practical examples, the book will then show you how to create and manage databases. You will learn how to secure PostgreSQL, perform administration and maintenance tasks, implement high availability features, and provide replication. The book will conclude by teaching you how to migrate information from other databases to PostgreSQL.

商品描述(中文翻譯)

超過90個實作食譜,幫助您有效管理、管理和設計使用PostgreSQL的解決方案

本書介紹



  • 實作一個高可用性的PostgreSQL資料庫伺服器,並執行PostgreSQL的管理和開發功能

  • 使用Perl和Python在PostgreSQL中執行資料庫操作

  • 逐步食譜,專注於提供實際的PostgreSQL解決方案

本書適合誰


如果您是系統管理員、資料庫管理員、架構師、開發人員,或對使用PostgreSQL規劃、管理和設計資料庫解決方案感興趣的人,本書非常適合您。如果您對任何關聯式資料庫或SQL語言有一些先前經驗,本書也適合您。

您將學到什麼



  • 執行定期維護任務,以保持資料庫穩定並達到最佳性能

  • 設計和實作各種高可用性和複製功能,以提供冗餘、容錯和故障轉移

  • 診斷和排除與CPU、記憶體和I/O相關的資料庫性能問題

  • 使用Perl和Python等語言執行資料庫操作

  • 探索可以在PostgreSQL中實作的不同備份和恢復策略

  • 實作連接池方法以達成負載平衡

詳細內容


PostgreSQL是一個開源的資料庫管理系統。它被用於各種開發實踐,例如軟體和網頁設計,以及處理大型數據集(大數據)。


本書旨在教您掌握PostgreSQL的技能,首先將讓您瞥見PostgreSQL的獨特功能以及如何利用這些功能解決實際問題。在實用範例的幫助下,本書將展示如何創建和管理資料庫。您將學習如何保護PostgreSQL、執行管理和維護任務、實作高可用性功能以及提供複製。最後,本書將教您如何將資訊從其他資料庫遷移到PostgreSQL。