How To Set Up Logical Replication with PostgreSQL 10 on Ubuntu

Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database

To configure replication slots, the Rivery user must be granted the REPLICATION role If the server does not already have a REPLICATION role, it can be created

create replication slot postgres You will create an example database with a sample table, which you can then use to test logical replication between your servers You will also

create replication slot Replication slots for High Availability A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby