AWS RDS for PostgreSQL seem to use different parameter names compared to the community edition. For example, instead of setting wal_level to logical, we need to set rds.logical_replication to 1. Similarly, there is a parameter rds.force_ssl. It looks like that is the equivalent of ssl in the community edition. Is there some place where I can find a good comparison/description of such differences?
2
As RDS is a managed DB service for most popular engines, RDS forks the community engine (Postgres in this case) and builds features and automation on top of it. Coming to your query about a place where there is a dedicated difference between the parameters on RDS v/s community engine, I would say there won’t be much difference in the parameters. Maybe you will find few parameters which are additional (modifiablle/non-modifiable) on RDS.
What I would recommend is to execute the system variables command on community as well as RDS instance to get a list of variables. Then compare and find what are those few variables which are different between RDS and community.
cloud_enthu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.