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

Chapter 4. Setting Up Asynchronous Replication

After performing our first PITR, we are ready to work on a real replication setup. In this chapter, you will learn how to set up asynchronous replication and streaming. The goal is to make sure that you can achieve higher availability and higher data security.

In this chapter, we will cover the following topics:

  • Configuring asynchronous replication

  • Understanding streaming

  • Combining streaming and archives

  • Managing timelines

At the end of this chapter, you will be able to easily set up streaming replication in a couple of minutes.