Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • PostgreSQL Replication, Second Edition
  • Toc
  • feedback
PostgreSQL Replication, Second Edition

PostgreSQL Replication, Second Edition

By : Hans-Jürgen Schönig
4.5 (4)
close
PostgreSQL Replication, Second Edition

PostgreSQL Replication, Second Edition

4.5 (4)
By: Hans-Jürgen Schönig

Overview of this book

This book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.
Table of Contents (17 chapters)
close
16
Index

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 block are applied. Basically, each type of filter comes in two incarnations: include_ and exclude_. In this example, only the spc_slave1 tablespace is included. The final setting says...

bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete