Book Image

PostgreSQL Administration Essentials

Book Image

PostgreSQL Administration Essentials

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
PostgreSQL Administration Essentials
Oct, 2014 | 142 pages
No titles found
Table of Contents (14 chapters)
PostgreSQL Administration Essentials
PostgreSQL Administration Essentials
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installing PostgreSQL
Installing PostgreSQL
Preparing your setup
Understanding the existing databases
Creating databases
Summary
2
Indexing and Performance Tuning
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
3
Users and Permissions
Users and Permissions
Understanding PostgreSQL security
Summary
4
Managing Logfiles
Managing Logfiles
Understanding the PostgreSQL log architecture
Configuring the amount of log output
Making log creation more fine grained
Summary
5
Backup and Recovery
Backup and Recovery
Importing and exporting data
Performing backups
Summary
6
Handling Replication and Improving Performance
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
7
Monitoring PostgreSQL
Monitoring PostgreSQL
Understanding the system statistics of PostgreSQL
Integrating Nagios
Handling Linux cgroups
Summary
Index
Index

Chapter 5. Backup and Recovery

In this chapter, you will learn all you need to know about backup and recovery in PostgreSQL. The following topics will be covered in this chapter:

  • Importing and exporting data

  • Performing simple dumps

  • Creating efficient custom-format dumps

  • Replaying dumps

  • Scaling up replay

Previous Section
End of Section 1
Next Section