Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


In this chapter, you learned about the purpose of the PostgreSQL transaction log. We talked extensively about the on-disk data format and some highly important topics, such as consistency and performance. All of them will be needed when we replicate our first database in the next chapter.

The next chapter will build on top of what you have just learned, and focus on Point-in-time-Recovery (PITR). Therefore, the goal will be to make PostgreSQL return to a certain point in time and provide data as if some later transactions never happened.