PostgreSQL 9 Administration Cookbook, 2nd Edition

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.

Table of Contents

Chapter 1: First Steps
Chapter 2: Exploring The Database
Chapter 3: Configuration
Chapter 4: Server Control
Chapter 5: Tables And Data
Chapter 6: Security
Chapter 7: Database Administration
Chapter 8: Monitoring And Diagnosis
Chapter 9: Regular Maintenance
Chapter 10: Performance And Concurrency
Chapter 11: Backup And Recovery
Chapter 12: Replication And Upgrades