By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Option to change wal_level in aurora postgresql

0

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

Topics
DatabaseMigration & ModernizationAnalytics
Tags
PostgreSQLAmazon Relational Database ServiceAurora PostgreSQL
Language
English
Anbazhagan
asked 2 months ago341 views
2 Answers
1
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

b

When creating a parameter group, the Type must be set to "DB Cluster Parameter Group".
c

profile picture
EXPERT
Riku_Kobayashi
answered 2 months ago
0

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

Anbazhagan
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content