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

· Packt Publishing Ltd
Ebook
88
Pages
Tools

About this ebook

Key Features
    Book DescriptionWritten 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. 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.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
    Who this book is for

    Key Features Book DescriptionWritten 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 chapt...

    Discover more

    About the author

    Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions

    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.

    Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with...

    Rate this ebook

    Tell us what you think.

    Reading information

    Smartphones and tablets
    Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
    Laptops and computers
    You can listen to audiobooks purchased on Google Play using your computer's web browser.
    eReaders and other devices
    To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.