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
Once found, how do I change it?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
To find out the wal_level you can use PSQL and execute:
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.