PostgreSQL 9 Administration Cookbook

by Simon Riggs, Gianni Ciolli, Hannu Krosing

Over 150 recipes to help you run an efficient PostgreSQL database in the cloudAbout This BookAdminister and maintain a healthy databaseMonitor your database to ensure maximum efficiencyTips and tricks for speedy backup and recoveryWho This Book Is ForThrough 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 LearnImplement PostgreSQL features for reliability and performanceHarness the power of the latest PostgreSQL 9.4 featuresManage PostgreSQL versions 9.0, 9.1, 9.2, 9.3, and 9.4Advanced technical tips for experienced usersExplore best practices for planning and designing live databasesSelect and implement robust backup and recovery techniquesConcise and clear guidance on replication and high availabilityLatest details on Logical Replication and Bi-Directional ReplicationIn DetailPostgreSQL 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.

Genres: Programming

506 pages, Kindle Edition

First published October 26, 2010

Reviews

[Shereef Sakr · Rating 5 out of 5]

A very good handbook on Postgresql administration. Very informative indeed.

[Alexey · Rating 4 out of 5]

Пособие отлично подойдет начинающим в освоении РСУБД PostgreSQL.
Очень много стоящих советов с примерами и подробными описаниями.
Лично мне очень помог этот справочник советов.

[Dina · Rating 4 out of 5]

It's a good book for quick resolutions and questions. Personally I prefer something much more in depth but this book gets the job done in as far as daily tasks.

[Kai · Rating 5 out of 5]

Good reference book. Written by 2ndQuadrant engineers.