PostgreSQL Administration Essentials

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

PostgreSQL Administration Essentials

Hans-Jürgen Schönig

1 customer reviews
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases
Mapt Subscription
FREE
€29.98/m after trial
eBook
€11.76
RRP €16.78
Save 29%
Print + eBook
€22.99
RRP €22.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
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 Mapt 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 Mapt 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 Mapt reader
€0.00
€11.76
€22.99
€29.98p/m after trial
RRP €16.78
RRP €22.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Book Details

ISBN 139781783988983
Paperback142 pages

Book Description

With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL makes it a powerful tool for your professional relational database infrastructure.

With the database administrator in mind, this compact, easy-to-read, and practically-oriented book will make your daily handling of PostgreSQL more efficient and rewarding. You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.

Table of Contents

Chapter 1: Installing PostgreSQL
Preparing your setup
Understanding the existing databases
Creating databases
Summary
Chapter 2: Indexing and Performance Tuning
Using simple binary trees
Understanding the concept of execution plans
Dealing with different types of indexes
Detecting missing indexes
Detecting slow queries
Adjusting memory parameters
Summary
Chapter 3: Users and Permissions
Understanding PostgreSQL security
Summary
Chapter 4: Managing Logfiles
Understanding the PostgreSQL log architecture
Configuring the amount of log output
Making log creation more fine grained
Summary
Chapter 5: Backup and Recovery
Importing and exporting data
Performing backups
Summary
Chapter 6: Handling Replication and Improving Performance
Understanding the PostgreSQL transaction log
Configuring the checkpoints
Setting up an asynchronous replication
Upgrading to synchronous replication
Improving and monitoring the replication
Handling point-in-time recovery
Understanding timelines
Summary
Chapter 7: Monitoring PostgreSQL
Understanding the system statistics of PostgreSQL
Integrating Nagios
Handling Linux cgroups
Summary

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

Authors

Table of Contents

Chapter 1: Installing PostgreSQL
Preparing your setup
Understanding the existing databases
Creating databases
Summary
Chapter 2: Indexing and Performance Tuning
Using simple binary trees
Understanding the concept of execution plans
Dealing with different types of indexes
Detecting missing indexes
Detecting slow queries
Adjusting memory parameters
Summary
Chapter 3: Users and Permissions
Understanding PostgreSQL security
Summary
Chapter 4: Managing Logfiles
Understanding the PostgreSQL log architecture
Configuring the amount of log output
Making log creation more fine grained
Summary
Chapter 5: Backup and Recovery
Importing and exporting data
Performing backups
Summary
Chapter 6: Handling Replication and Improving Performance
Understanding the PostgreSQL transaction log
Configuring the checkpoints
Setting up an asynchronous replication
Upgrading to synchronous replication
Improving and monitoring the replication
Handling point-in-time recovery
Understanding timelines
Summary
Chapter 7: Monitoring PostgreSQL
Understanding the system statistics of PostgreSQL
Integrating Nagios
Handling Linux cgroups
Summary

Book Details

ISBN 139781783988983
Paperback142 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

PostgreSQL 9.0 High Performance Book Cover
PostgreSQL 9.0 High Performance
€ 28.78
€ 20.16
PostgreSQL Server Programming Book Cover
PostgreSQL Server Programming
€ 28.78
€ 5.76
Mastering Object-oriented Python Book Cover
Mastering Object-oriented Python
€ 23.98
€ 16.80
PostgreSQL 9 Admin Cookbook Book Cover
PostgreSQL 9 Admin Cookbook
€ 28.78
€ 20.16
PostgreSQL for Data Architects Book Cover
PostgreSQL for Data Architects
€ 40.78
€ 28.56
PostgreSQL Replication Book Cover
PostgreSQL Replication
€ 28.78
€ 20.16