Quick Setup

Set the following configuration items in the postgresql.conf file:

wal_level = logical

For a basic setup, retain the default values for the other necessary configuration items.

You need to adjust the pg_hba.conf file to allow replication (the value depends on the actual network configuration and the user used for connection).

host     all     repuser     0.0.0.0/0     sha256

In the publisher database:

CREATE PUBLICATION mypub FOR TABLE users, departments;

In the subscriber database:

CREATE SUBSCRIPTION mysub CONNECTION 'dbname=foo host=bar user=repuser' PUBLICATION mypub;

The above statements start the replication process, replicating incremental changes to those tables.