PostgreSQL 9 Administration Cookbook, 2/e (Paperback)

Over 150 recipes to help you run an efficient PostgreSQL database in the cloud

About This Book

• Administer and maintain a healthy database
• Monitor your database to ensure maximum efficiency
• Tips and tricks for speedy backup and recovery

Who This Book Is For

Through example-driven recipes, with plenty of code, focused on the most vital features of the latest PostgreSQL version (9.4), both administrators and developers will follow short, specific guides to understand and leverage useful Postgre functionalities to create better and more efficient databases.

In Detail

PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world's most popular server databases with an enviable reputation for performance and stability and an enormous range of advanced features.

Starting with short and simple recipes to get you back up and running with an exploration of the ins and outs of your database, you will soon dive into core features such as configuration, server control, tables, and data. This is a practical guide aimed at giving sysadmins and database administrators the necessary toolkit to be able to set up, run, and extend powerful databases with PostgreSQL.

超過150個食譜，幫助您在雲端中運行高效的PostgreSQL數據庫

關於本書
- 管理和維護健康的數據庫
- 監控數據庫以確保最大效率
- 提供快速備份和恢復的技巧和訣竅

本書適合對象
通過以實例為驅動的食譜，並提供大量代碼，專注於最新版本（9.4）的PostgreSQL的最重要功能，系統管理員和開發人員將遵循簡短而具體的指南，以了解和利用有用的PostgreSQL功能，從而創建更好、更高效的數據庫。

詳細內容
PostgreSQL是一個強大的開源對象關係數據庫系統，正迅速成為世界上最受歡迎的服務器數據庫之一，以其出色的性能和穩定性以及豐富的高級功能而聞名。

從短小簡單的食譜開始，讓您重新瞭解和運行數據庫的各個方面，然後深入探討配置、服務器控制、表格和數據等核心功能。這是一本實用指南，旨在為系統管理員和數據庫管理員提供必要的工具，以便能夠使用PostgreSQL設置、運行和擴展強大的數據庫。