PostgreSQL Replication - Second Edition

Using additional configuration options

The walbouncer tool can do a lot more for users than has been outlined so far. A couple of additional configuration parameters are available.

The first example shows what can be done if more than one slave is around:

listen_port: 5433
master:
    host: localhost
    port: 5432
configurations:
    - slave1:
        match:
            application_name: slave1
        filter:
            include_tablespaces: [spc_slave1]
            exclude_databases: [test]

Inside the configuration block, there is the slave1 section. The slave1 configuration will be chosen if a slave connects itself using slave1 as application_name (as outlined in the application_name clause). If this configuration is chosen by the server (there can be many such slave sections), the filters listed in the next ...