PostgreSQL Cookbook

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的解決方案

關於本書

- 使用Perl和Python在PostgreSQL中執行數據庫操作
- 逐步的食譜專注於提供真實世界的PostgreSQL解決方案

本書適合對使用PostgreSQL規劃、管理和設計數據庫解決方案感興趣的系統管理員、數據庫管理員、架構師、開發人員或任何人。如果您具有任何關聯數據庫或SQL語言的先前經驗，本書適合您。

您將學到什麼

- 執行定期維護任務，使您的數據庫穩定並實現最佳性能
- 設計和實施各種高可用性和複製功能，提供冗余、容錯和故障轉移
- 診斷和解決與CPU、內存和I/O相關的數據庫性能問題
- 使用Perl和Python等語言執行數據庫操作
- 發現可以在PostgreSQL中實施的不同備份和恢復策略
- 實施連接池方法以實現負載平衡

詳細內容

PostgreSQL是一個開源的數據庫管理系統。它被用於各種開發實踐，如軟件和網頁設計，以及處理大型數據集（大數據）。

為了教授您掌握PostgreSQL的技能，本書首先讓您瞭解PostgreSQL的獨特功能以及如何利用它們解決實際問題。通過實際示例的幫助，本書將向您展示如何創建和管理數據庫。您將學習如何保護PostgreSQL，執行管理和維護任務，實施高可用性功能並提供複製。本書將以教授您如何將信息從其他數據庫遷移到PostgreSQL結束。