Option to change wal_level in aurora postgresql

Question

Hi team,

Is the wal_level modifiable from replica to logical in aurora PostgreSQL ?
I can see rds.logical_replication as modifiable parameter. But when I create a new parameter group for Aurora, it is not listed. I could change it for rds PostgreSQL - changing rds.logical_replication from 0 to 1.

Please note that I could not do the same as mentioned in https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.Logical.html

Accepted Answer

Hello.

Did you select cluster parameter group instead of instance parameter group when creating the parameter group?  
We confirmed that "rds.logical_replication" is not included in the instance parameter group.  
![a](/media/postImages/original/IM4ifTrxjRQRyXjX2IN9Y2qA)

![b](/media/postImages/original/IM8ryBhWF0RF-NyXvRE0Pu2Q)

When creating a parameter group, the Type must be set to "DB Cluster Parameter Group".  
![c](/media/postImages/original/IMoUshOSgSTKmtBDB_QuyIJA)

Answer

It worked fine, thanks a lot for the very swift response.

Option to change wal_level in aurora postgresql

Contenuto pertinente