Setup

Non-AWS

• Ensure Postgres database user is a superuser (this is required to query replication slots)

   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