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

Adjusting filtering rules


One question that is often asked is whether it is possible to adjust filtering rules. Objects might be added later, or objects might be removed. In many cases, this is a very common scenario people ask for on a regular basis.

Changing the configuration of a walbouncer setup is not as simple as it might seem. The core problems are synchronizing the XLOG and making sure that all the dependent objects are in place. Let's go through the core challenges one by one.

Removing and filtering objects

Basically, removing objects is fairly simple. The first thing to do is to shut down the slave as well as walbouncer. Once this is done, those objects that are not needed anymore can be physically deleted from the filesystem of the slave. The crucial part here is finding those objects. Again, digging into the system tables is the method of choice here. The core system tables or views involved are as follows:

  • pg_class: This table contains a list of objects (tables, indexes, and so...