O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reloading server configuration

In this recipe, we will talk about the command that can be used to reload the server configuration and its parameters.

Getting ready

If any of the server parameters come into effect after reloading the server configuration files, such as postgresql.conf, then we need to reload the server configuration using the reload option of the pg_ctl command.

How to do it...

We can use the following command to reload the server configuration on Red Hat-based Linux and Unix distributions:

pg_ctl -D /var/lib/pgsql/9.6/data reload

You can also reload the configuration using the pg_reload_conf function while still being connected to PostgreSQL .The usage of the pg_reload_conf function is mentioned as follows:

postgres=# select pg_reload_conf(); ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required