List PostgreSQL configuration items which require a server restart

Some PostgreSQL configuration items - typically set in postgresql.conf - require a server restart to become effective.

Use the view pg_settings to list the items which require a restart:

SELECT name FROM pg_settings WHERE context='postmaster'

From PostgreSQL 9.5, pg_settings contains a field pending_restart which indicates configuration items requiring a server restart have changed and are awaiting a restart.

In PostgreSQL 9.2 the settings are:

See also: PostgreSQL documentation - pg_settings