Have a personal or library account? Click to login
PostgreSQL Administration Essentials Cover

PostgreSQL Administration Essentials

Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases

Publisher:Packt Publishing Limited
Paid access
|Sep 2025
Product purchase options

Key Features

    Book Description

    If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.

    What you will learn

    • Perform routine backups and restore your databases safely
    • Set up replication quickly and easily
    • Handle logfiles and extract information from PostgreSQL
    • Monitor PostgreSQL and integrate it into the existing infrastructure
    • Build desktop applications using C#
    • Optimize PostgreSQL for high speed and tune your database parameters
    • Adjust your user permissions and lock out intruders
    • Detect bottlenecks and find missing indexes with ease

    Who this book is for

    Table of Contents

    1. Installing PostgreSQL
    2. Indexes and performance tuning
    3. Users and permissions
    4. Log file handling
    5. Backup and recovery
    6. PostgreSQL replication
    7. Monitoring PostgreSQL
    PDF ISBN: 978-1-78398-899-0
    Publisher: Packt Publishing Limited
    Copyright owner: © 2014 Packt Publishing Limited
    Publication date: 2025
    Language: English
    Pages: 142

    People also read