Have a personal or library account? Click to login
PostgreSQL 9 Administration Cookbook - Second Edition Cover

PostgreSQL 9 Administration Cookbook - Second Edition

Over 150 recipes to help you run an efficient PostgreSQL database in the cloud

Paid access
|May 2015
Product purchase options

Key Features

    Book Description

    Through 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 learn

    • Implement PostgreSQL features for reliability and performance
    • Harness the power of the latest PostgreSQL 9.4 features
    • Manage PostgreSQL versions 9.0, 9.1, 9.2, 9.3, and 9.4
    • Advanced technical tips for experienced users
    • Explore best practices for planning and designing live databases
    • Select and implement robust backup and recovery techniques
    • Concise and clear guidance on replication and high availability
    • Latest details on Logical Replication and BiDirectional Replication

    Who this book is for

    Through 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.

    Table of Contents

    1. First Steps
    2. Exploring the Database
    3. Configuration
    4. Server Control
    5. Tables & Data
    6. Security
    7. Database Administration
    8. Monitoring & Diagnostics
    9. Regular Maintenance
    10. Performance & Concurrency
    11. Backup & Recovery
    12. Replication & Upgrades
    13. Preface
    PDF ISBN: 978-1-84951-907-6
    Publisher: Packt Publishing Limited
    Copyright owner: © 2015 Packt Publishing Limited
    Publication date: 2015
    Language: English
    Pages: 504