Setup

Non-AWS

• Ensure Postgres database user is a superuser

   SELECT usename FROM pg_user WHERE usesuper = true
  

• Enable logical decoding in postgres.conf

wal_level = logical

- Ensure there is at least one replication slot defined in postgres.conf

max_replication_slots = 1

AWS

• Ensure Postgres database user is a superuser

  GRANT rds_superuser TO <username>
  

• Enable logical_replication by using the parameter group settings described here