Amazon Postgres RDS pg_stat_statements not loaded

amazon-rds, amazon-web-services, postgresql

Solution

Ran into the same problem today.

Turns out I simply had to reboot the database (via CLI or web interface).

As mentioned on the AWS docs:

When you change a static parameter and save the DB parameter group, the parameter change takes effect after you manually reboot the DB instance.

Problem

I configured my RDS Postgres 9.6.1 instance so, that the pg_stat_activity is loaded via 'shared_preload_libraries' parameter ``` shared_preload_libraries=pg_stat_statements,pg_hint_plan ``` The I rebooted my instance and then check if the pg_stat_statements can be loaded. But I get the error: ``` [55000] ERROR: pg_stat_statements must be loaded via shared_preload_libraries ``` The command ``` SHOW shared_preload_libraries; ``` does not show the pg_stat_statements library. And therefore the error above still remains. Does somebody else has got the same issue?

Original source