snippetsqlMajor
How to set the wal_level in AWS RDS Postgresql?
Viewed 0 times
postgresqlthewal_levelawshowrdsset
Problem
How do I know which
I checked 'parameter groups', but was unable to find the
Once found, how do I change it?
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?
Solution
To find out the wal_level you can use PSQL and execute:
You need to set
I found some details here
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
Context
StackExchange Database Administrators Q#238686, answer score: 27
Revisions (0)
No revisions yet.