Stay up to date with the latest from the Knowledge Center. See all new and updated Knowledge Center articles published in the last month and re:Post’s top contributors.
RDS pgaudit parameters not dynamic
1
pgaudit.* parameters in the RDS param group appear as "Dynamic" but actually require the instance to be rebooted in order to apply changes for these parameters' value.
Language
English
asked 9 months ago278 views
1 Answer
- Newest
- Most votes
- Most comments
-2
Hello,
To enable pgaudit, you must add a value to shared_preload_libraries parameter and it listed as a static parameter in RDS.
References:
Relevant content
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 3 years ago
I'm not talking about thew "shared_preload_libraries" parameter as the pgaudit extension is already loaded and running. I was referring to the "pgaudit.*" parameters only.
If you notice clause #16 in the second document you've sent, it says: "Choose your RDS for PostgreSQL DB instance from the Databases list to select it, and then choose Reboot from the Actions menu."
So if the RDS instance needs to be rebooted then why are these parameters considered "Dynamic" and not "Static"?