Unable to replicate from Postgress source endpoint to Postgress target

[desmondchew]

I am using a postgress admin account. Both source and target endpoint are Postgress in AWS RDS.

However I hit into the followin error while trying to start a task to replicate several tables.

Can you please help?

Creating replication slot 'inhouse_app_test_00081414_94626a79_663a_434e_a4bf_293d2148fae3' failed.
wal_slot_create(...) - Unable to create slot 'inhouse_app_test_00081414_94626a79_663a_434e_a4bf_293d2148fae3' (on execute(...) phase)
RetCode: SQL_ERROR SqlState: 55000 NativeError: 1 Message: ERROR: logical decoding requires wal_level >= logical;
Error while executing the query
Failed (retcode -1) to execute statement: 'SELECT lsn FROM pg_create_logical_replication_slot('inhouse_app_test_00081414_94626a79_663a_434e_a4bf_293d2148fae3', 'test_decoding')'

Thanks
Desmond

[desmondchew]

Hi,

Both my source and target endpoints are using AWS Postgress RDS. It already has "max_replication_slot=20" as default. Meanwhile there's no option to overwrite for parameter "wal_level".

Not sure how we can resolve this.

Thanks
Desmond

[desmondchew · Accepted solution]

I resolved this by setting the RDS parameter "rds.logical_replication"=1. This helped to set wal_level=logical behind the scene.