PostgreSQL Replication - Second Edition

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. ...