Creating a publication set

The first component to successfully upgrading a PostgreSQL cluster while fully online is building a pglogical publication set. This publication set will represent all the data we want on the new cluster, and gives us an opportunity to prune anything that should be deprecated.

Unlike previous forays into logical replication, we will actually need to entertain some extra considerations. This recipe will explain how to build a publication set that ensures a smooth major version upgrade.

Getting ready

The Remembering PgBouncer and pglogical recipe already recommended reviewing the material on pglogical. We also suggest actually following the Setting up pglogical recipe in Chapter 7, PostgreSQL Replication...