PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

Simon Riggs, Hannu Krosing

RRP $9.99
RRP $19.99
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection
Free Sample

Book Details

ISBN 139781849516426
Paperback88 pages

About This Book

  • Administer and maintain a healthy database
  • Configure your PostgreSQL database to your needs
  • Monitor your database and learn to diagnose any problems
  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Who This Book Is For

This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. The book assumes that you are familiar with the basic operation of PostgreSQL.

Table of Contents

What You Will Learn

  • Change parameters in your system and find out how that will affect the rest of your database
  • Summaries to help DBAs with experience of other database systems
  • Monitor your users so that you can see whether they are connected, what they are running, and whether their account has become blocked
  • Identify temporary data and the effect that it has on your system
  • Advanced technical tips and scripts for experienced users
  • Control the automatic database maintenance program
  • Identify and fix bloated tables and indexes
  • How and when to VACUUM your databases

In Detail

PostgreSQL is a powerful, open source, enterprise database.

This PostgreSQL 9 Administration Cookbook LITE book describes key aspects of the PostgreSQL open source database system. The book will help a sysadmin or DBA with key administration issues in PostgreSQL: configuration, monitoring and diagnosis, and setting up regular maintenance. This hands-on guide will assist developers working on live databases supporting web or enterprise software applications.

To find out more about upgrading to the full edition, visit and log into your account for offers and help. If you don’t have an account on, visit today and set one up!


Table of Contents

Book Details

ISBN 139781849516426
Paperback88 pages
Read More