May 2018
Intermediate to advanced
576 pages
30h 25m
English
Some of the parameters take effect only when the server is first started. A typical example might be shared_buffers, which defines the size of the shared memory cache.
Many of the parameters can be changed while the server is still running. After changing the required parameters, we issue a reload command to the server, forcing PostgreSQL to reread the postgresql.conf file (and all other configuration files). There are a number of ways to do that, depending on your distribution and OS. The most common is to issue the following command, with the same OS user that runs the PostgreSQL server process:
pg_ctl reload
This assumes the default data directory; otherwise, you have to specify the correct data directory with the -D option. ...