For Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, database settings are modified within parameter groups.

Review the Amazon AWS documentation for information on how to edit database settings within a new parameter group and assign it to a database instance:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html

• Ensure that the database configuration settings listed previously are correct, by verifying them in the parameter group assigned to the instance.

• The wal_level setting for Amazon database services is configured with a parameter called rds.logical_replication, whose default is 0 and should be set to 1 if the database is to be used a source database for Oracle GoldenGate Extract.

• Amazon RDS does not support prepending or starting the replication slot name with the string rds. The command used by Oracle GoldenGate Extract to create the replication slot returns an error if the replication slot name starts with the string rds. For example, you could name the replication slot as ordscdc instead of rdscdc to avoid this error, as shown in the following example:

  select slot_name from  pg_create_logical_replication_slot('ordscdc',
  'test_decoding');

  This command adds the ordscdc replication slot. However, if you use the replication slot name as rdscdc, the following error will occur:

  ERROR:  must be superuser or replication role to use logical replication  slots in the 'rds'
  namespace

Limitation:

On Amazon Aurora PostgreSQL version 12.17, if upper case SHOW command is executed, it reports the following error:

"ERROR: must be superuser or replication role to run this operation."

You must use lower case SHOW command to avoid this error.