How to set the wal_level in AWS RDS Postgresql?

Question

How do I know which wal_level my AWS RDS Postgres 11.1 database has?

I checked 'parameter groups', but was unable to find the wal_level.

Once found, how do I change it?

score 28 · Accepted Answer · answered Jul 23 '19 at 18:04

28

To find out the wal_level you can use PSQL and execute: show wal_level; You need to set rds.logical_replication parameter to 1. It will automatically change wal_level to logical.

I found some details here

answered Jul 23 '19 at 18:04

er_the_red

296
4
3

score 0 · Answer 2 · answered Apr 21 '20 at 13:25

With RDS Postgresql or Aurora Postgresql, you can only work on logical replication, because we can find the paramter rds.logical_replication and change it to 1 to enable it. But, you can't find the parameter wal_level or I have also tried searching for rds.streaming_replication to turn on streaming replication but, you cannot find them.

How to set the wal_level in AWS RDS Postgresql?

2 Answers2