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?
Add a comment
|
2 Answers
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
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.