Introducing our new eBook: "Best Practices for Optimizing Postgres Query Performance"Download Now

S9: Reloading configuration files

Category: Server Events
SQLSTATE: Depending on the situation, F0000 (Class F0 - Configuration File Error: config_file_error)
Urgency: low

Example Postgres Log Output:

LOG: received SIGHUP, reloading configuration files
LOG: parameter "log_autovacuum_min_duration" changed to "0"
LOG: parameter "shared_preload_libraries" cannot be changed without restarting the server
LOG: configuration file "/var/lib/postgresql/data/postgresql.auto.conf" contains errors; unaffected changes were applied

Explanation:

This notice will be shown when the PostgreSQL server reloads, based on an operator request.

It will also log out any configuration parameters that may have been changed as part of this reload, as well as any parameters that can't be changed because they require a restart.

Recommended Action:

Usually no action needs to be taken, as this was operator initiated.

In some cases you might want to verify that the config parameter change got applied, and that you didn't accidentally make a typo in the config file, or tried to change a config parameter that requires a full restart.

Learn More:

No additional resources available.


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →