O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

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 the server configuration files

Some PostgreSQL configuration parameters can only be changed by "reloading" the whole configuration file.

How to do it...

On all platforms, there is a specific command to reload the server, which is as follows:


UBUNTU/DEBIAN 				pg_ctlcluster 9.0 main reload
RED HAT/FEDORA 				service postgresql reload
							pg_ctl -D /var/lib/pgsql/data reload
SOLARIS 					pg_ctl -D /var/lib/pgsql/data reload
MAC OS 						pg_ctl -D /var/lib/pgsql/data reload
FREEBSD 					pg_ctl -D /var/lib/pgsql/data reload

You can also reload the configuration files while still connected to PostgreSQL. This can be done from the command line as follows, if you are a superuser:

postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t

which is also often ...

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