Verify your knowledge

• What is a configuration context?

  A configuration context defines how the cluster will perceive changes to a configuration parameter – for example, only at boot time or at the next incoming connection. See the Configuration contexts section for more details.

• What is the difference between the catalogs pg_settings and pg_file_settings?

  The pg_settings catalog shows the values of every configuration parameter, as well as its admitted and valid values; the pg_file_settings catalog shows where (i.e., in which file and at which line) a configuration parameter has been found and loaded. See the Inspecting all configuration parameters section for more details.

• Besides editing configuration files, how can you modify the cluster configuration via SQL statements?

  You can issue an ALTER STATEMENT command to change the values of a configuration setting. Changes will be written into the postgresql.auto.conf file....