Question:
I configured my RDS Postgres 9.6.1 instance so, that the pg_stat_activity is loaded via ‘shared_preload_libraries’ parameter
|
1 2 |
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:
|
1 2 |
[55000] ERROR: pg_stat_statements must be loaded via shared_preload_libraries |
The command
|
1 2 |
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 ?
Thanks,
Detlef
Answer:
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.