Skip to content

Setup

  • 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

  • Ensure Postgres database user is a superuser
    GRANT rds_superuser TO <username>
    
  • Enable logical_replication by using the parameter group settings describer here