Collection : Postgres

Postgres on

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.

databases •
postgres