18
Logical Replication
In the previous chapter, we talked about WAL segments and physical replication in synchronous, asynchronous, and cascading modes. In this chapter, we will cover the topic of logical replication. We will look at how to perform a logical replica, how a logical replication is different from a physical replication, and when it’s better to use logical replication instead of physical. We’ll also see that logical replication can be used to make a PostgreSQL hot upgrade. This chapter is intended as an introduction to logical replication; for further information, refer to more advanced texts, such as Mastering PostgreSQL, by Hans-Jürgen Schönig.
This chapter covers the following topics:
- Understanding the basic concepts of logical ...
Get Learn PostgreSQL - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
