Issue with AWS DMS continuous replication

Question

I am trying to create a DMS task to migrate data from RDS Postgres instance to S3 bucket. The full load works all fine, but the continuous replication is failing. Its giving this error:

"logical decoding requires wal_level >= logical"

When I checked the system settings from pg_settings, its showing that the setting "wal_level" has value "replica". So I tried to change the setting wal_level, but I am not able to find this setting in the Parameter Group in RDS. My RDS instance is using 9.6 version of parameters.

When I tried "ALTER SYSTEM SET wal_level TO 'logical'", it fails saying that "must be superuser to execute ALTER SYSTEM command", even though the user is under rds_superuser role.

Please suggest.

score 17 · Accepted Answer · answered Aug 10 '17 at 04:26

17

The Parameter name in Parameter Group is "rds.logical_replication" which needs to be changed to 1. The default value was 0.

This property changed "wal_level" value to "Logical".

answered Aug 10 '17 at 04:26

Zinx

2,113
3
27
37

7

I needed to restart my RDS instance after updating this value in my parameter group in order to clear this error. – ryantuck Aug 22 '18 at 22:14
@ryantuck life-saver – Hussein Hijazi Dec 02 '20 at 14:05
I'm surprised this is not mentioned in the documentation, thanks folks! – Jan Richter May 19 '21 at 02:02

Issue with AWS DMS continuous replication

1 Answers1