PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

Code Files

PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

Simon Riggs, Hannu Krosing

May 2011

Quick links: > What will you learn?

Packt Subscription

FREE

€9.44/m after trial

eBook

€6.72

RRP €9.58

Save 29%

Print + eBook

€14.99

RRP €14.99

What do I get with a Packt subscription?

Exclusive monthly discount - no contract
Unlimited access to entire Packt library of 6500+ eBooks and Videos
120 new titles added every month, on new and emerging tech

What do I get with an eBook?

Download this book in EPUB, PDF, MOBI formats
DRM FREE - read and interact with your content when you want, where you want, and how you want
Access this title in the subscription reader

What do I get with Print & eBook?

Get a paperback copy of the book delivered to you
Download this book in EPUB, PDF, MOBI formats
DRM FREE - read and interact with your content when you want, where you want, and how you want
Access this title in the subscription reader

What do I get with a Video?

Download this Video course in MP4 format
DRM FREE - read and interact with your content when you want, where you want, and how you want
Access this title in the subscription reader

€0.00

€6.72

€14.99

€9.44 p/m after trial

RRP €9.58

RRP €14.99

Subscription

eBook

Print + eBook

Start a FREE 10-day trial

Frequently bought together

PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

€ 9.58

€ 6.72

PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance

May 2011

88 pages

€ 6.72

Instant Debian - Build a Web Server

€ 16.78

€ 11.76

Instant Debian - Build a Web Server

Sep 2013

74 pages

€ 11.76

Buy 2 for €18.48
Save €6.58

Add to Cart

Book Details

ISBN 139781849516426

Paperback88 pages

Book Description

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 www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!

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

Authors

Simon Riggs

Simon Riggs is the CTO of 2ndQuadrant, having contributed to PostgreSQL as a major developer and committer for 14 years. He has written and designed features for replication, performance, BI, management, and security. Under his guidance, 2ndQuadrant is now a leading developer of open source PostgreSQL, serving hundreds of clients in USA, Europe, and worldwide. Simon is a frequent speaker at many conferences on PostgreSQL Futures. He has worked as a database architect for 30 years.

Hannu Krosing

Hannu Krosing is a principal consultant at 2ndQuadrant and a technical advisor at Ambient Sound Investments. As the original database architect at Skype Technologies, he was responsible for designing the SkyTools suite of replication and scalability technology. He has worked with and contributed to the PostgreSQL project for more than 12 years.