Product Documentation

Appearance

PG_RELOAD_CONF() ​

Reload the system-level configuration after modifying one or more parameters.

pg_reload_conf();

For example:

yellowbrick=# select pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

This function returns a BOOLEAN data type.

Typically, you would run this function after modifying one or more parameters that do not require a database restart. For example:

premdb=# show enable_alternative_round;
 enable_alternative_round 
--------------------------
 off
(1 row)

premdb=# alter system set enable_alternative_round to on;
WARNING:  Will be effective after the next server configuration reload, or after the next server restart in the case of parameters that can only be changed at server start
ALTER SYSTEM
premdb=# select pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

premdb=# \c premdb bobr
Password for user bobr: 
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
You are now connected to database "premdb" as user "bobr".
premdb=> show enable_alternative_round;
 enable_alternative_round 
--------------------------
 on
(1 row)

See also ALTER SYSTEM, SHOW, and Configuration Parameters.

Note: This reload function is not supported in queries with table references in the FROM clause.

Parent topic:System Functions