Modifying Your PostgreSQL Config File
Modifying your local PostgreSQL configuration is a way to practice changes that you might want to perform in your production PostgreSQL instance. With cloud providers, you may use a web UI or CLI program to modify parameters and not edit a config file directly, but the parameter names, values, and change process are about the same. Depending on which parameters you are changing, either you will be able to reload the configuration without restarting PostgreSQL, or you’ll need to restart PostgreSQL for the changes to be applied.
First, you’ll need to find the config file. From psql, run the following statement to find the path:
| | -- Connected as `postgres` |
| | -- Connect as `owner`, ... |
Get High Performance PostgreSQL for Rails now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
