What this book covers

Chapter 1, Installing PostgreSQL, introduces you to the installation process and helps in learning how to install binaries, as well as, to compile PostgreSQL from source.

Chapter 2, Indexing and Performance Tuning, introduces you to indexes. This chapter is entirely dedicated to indexes, as well as, to performance-related issues. Indexes are a corner stone when it comes to performance and; therefore, a lot of focus is on indexes.

Chapter 3, Users and Permissions, introduces you to the security system. The basic concepts of the PostgreSQL security system, as well as, some advanced concepts are outlined in this chapter.

Chapter 4, Managing Logfiles, covers the managing of logfiles.

Chapter 5, Backup and Recovery, outlines how textual backups can be created and restored, as saving and restoring data is an essential task of every system administrator.

Chapter 6, Handling Replication and Improving Performance, covers various flavors of replication, as well as, PITR. Synchronous, as well as, asynchronous replications are also covered in this chapter.

Chapter 7, Monitoring PostgreSQL, covers monitoring to make sure that your systems are available and productive. To make sure that PostgreSQL stays up and running, monitoring is an important topic.