PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance


PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance
eBook: $9.99
Formats: PDF, PacktLib, ePub and Mobi formats
$8.49
save 15%!
Print + free eBook + free PacktLib access to the book: $29.98    Print cover: $19.99
$19.99
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 88 pages [ mm x mm ]
Release Date : May 2011
ISBN : 1849516421
ISBN 13 : 9781849516426
Author(s) : Simon Riggs, Hannu Krosing
Topics and Technologies : All Books, Big Data and Business Intelligence, Lite Editions

Table of Contents

Preface
Chapter 1: Configuration
Chapter 2: Monitoring and Diagnosis
Chapter 3: Regular Maintenance
Index
  • Chapter 1: Configuration
    • Introduction
    • Reading the Fine Manual (RTFM)
    • Planning a new database
    • Changing parameters in your programs
    • What are the current configuration settings?
    • Which parameters are at non-default settings?
    • Updating the parameter file
    • Setting parameters for particular groups of users
    • Basic server configuration checklist
    • Adding an external module to PostgreSQL
    • Running server in power saving mode
    • Chapter 2: Monitoring and Diagnosis
      • Introduction
      • Is the user connected?
      • What are they running?
      • Are they active or blocked?
      • Who is blocking them?
      • Killing a specific session
      • Resolving an in-doubt prepared transaction
      • Is anybody using a specific table?
      • When did anybody last use it?
      • How much disk space is used by temporary data?
      • Why are my queries slowing down?
      • Investigating and reporting a bug
      • Producing a daily summary of logfile errors
      • Chapter 3: Regular Maintenance
        • Introduction
        • Controlling automatic database maintenance
        • Avoiding auto freezing and page corruptions
        • Avoiding transaction wraparound
        • Removing old prepared transactions
        • Actions for heavy users of temporary tables
        • Identifying and fixing bloated tables and indexes
        • Maintaining indexes
        • Locating the unused indexes
        • Carefully removing unwanted indexes
        • Planning maintenance

        Simon Riggs

        Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide. Simon has worked with enterprise-class database applications for more than 20 years, with prior certifications on Oracle, Teradata and DB2. Simon is responsible for much of the database recovery and replication code in PostgreSQL, and designed or wrote many of the latest performance enhancements. He uses his operational experience to contribute to many aspects of both internal design and usability.


        Hannu Krosing

        Hannu Krosing was a PostgreSQL user before it was rewritten to use SQL as its main query language in 1995. So, he has both the historic perspective of its development and almost 20 years of experience using it for solving various real-life problems. Hannu was the first Database Administrator and Database Architect at Skype, where he invented the sharding language PL/Proxy that allows scaling the user database to work with billions of users. Since leaving Skype at the end of 2006—about a year after it was bought up by eBay—Hannu has been working as a PostgreSQL consultant with 2ndQuadrant, the premier PostgreSQL consultancy with global reach and local presence in most of the world. Hannu has co-authored another Packt Publishing book, PostgreSQL 9 Administration Cookbook, together with one of the main PostgreSQL developers, Simon Riggs.
        Sorry, we don't have any reviews for this title yet.

        Submit Errata

        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

        Sorry, there are currently no downloads available for this title.

        Compare Books

        See which product is right for you

        PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance PostgreSQL 9 Admin Cookbook

        Lite Edition

        Learn more

        Full Edition

        Learn more
        Administer and maintain a healthy database 
        Configure your PostgreSQL database to your needs 
        Monitor your database and learn to diagnose any problems
        eBook available as PDF downloads
        eBook available as ePub downloads
        Available on PacktLib
        Over 80 recipes to help you run an efficient PostgreSQL 9.0 database
        Tips for backup and recovery of your database
        Price $19.99
        $49.99

        Frequently bought together

        PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance +    Microsoft Dynamics CRM 2011: Dashboards Cookbook =
        50% Off
        the second eBook
        Price for both: $25.40

        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

        What you will learn from this book

        • 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 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!

        Approach

        Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases in PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order.

        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.

        Code Download and Errata
        Packt Anytime, Anywhere
        Register Books
        Print Upgrades
        eBook Downloads
        Video Support
        Contact Us
        Awards Voting Nominations Previous Winners
        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
        Resources
        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software