Postgres
on
histre
amaan-ngp
Terraforming RDS — Part 3. Our struggles with parameter groups | by Muffy Barkocy | tech-at-instacart
tech.instacart.com
Terraforming RDS — Part 3
If you were administering your own PostgreSQL instance, you would set these values in various ways:
- In the server configuration file,
postgresql.conf - On the command line when starting the server
- In the database directly, using SQL to set values
Using AWS RDS, you don’t have access to the configuration file or the server startup command so AWS provides the “parameter group” resource to configure your RDS instance on startup.
#databases #postgres
Highlights
dynamic and static parameters Notice the “Apply type” column in the screenshot above. If the value in this column is “dynamic” then the value can be set or updated while the server is running. If it is “static” then the server must be restarted for the parameter to take effect. Since a parameter group is a separate resource from the RDS instance, you can update a static parameter value in the parameter group without restarting the server; AWS will store the change to be applied later.
Collect and share the web
Get started for free