PostgreSQL 9 Administration Cookbook - Softcover

Riggs, Simon; Ciolli, Gianni; Krosing, Hannu; Bartolini, Gabriele

Softcover

ISBN 10: 1849519064 ISBN 13: 9781849519069

Publisher: Packt Pub Ltd, 2015

Synopsis

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.

What You Will Learn

• Implement PostgreSQL features for reliability and performance
• Harness the power of the latest PostgreSQL 9.4 features
• Manage PostgreSQL versions 9.0, 9.1, 9.2, 9.3, and 9.4
• Advanced technical tips for experienced users
• Explore best practices for planning and designing live databases
• Select and implement robust backup and recovery techniques
• Concise and clear guidance on replication and high availability
• Latest details on Logical Replication and Bi-Directional Replication

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.

About this title

About the Author

Simon Riggs

Simon Riggs is the CTO of 2ndQuadrant and an active PostgreSQL committer. He has contributed to PostgreSQL as a major developer for more than 10 years, having written and designed many new features in every release over that period. His feature credits include replication, performance, business intelligence, management, and security. Under his guidance, 2ndQuadrant is now a leading developer of open source PostgreSQL and a platinum sponsor of the PostgreSQL Project, serving hundreds of clients in USA, Europe, Asia-Pacific,the Middle East, and Africa. Simon is a frequent speaker at many conferences and is well known for his speeches on PostgreSQL Futures and different aspects of replication. He has worked with many different databases as a developer, architect, data analyst, and designer with companies across USA and Europe for nearly 30 years.

Edition details

• Publisher: Packt Pub Ltd
• Publication date: 2015
• ISBN 10: 1849519064
• ISBN 13: 9781849519069
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 475