Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Monitoring Changes to Configuration Parameters

Jim Knicely authored this tip.

The CONFIGURATION_CHANGES system table records the change history of system configuration parameters. This information is useful for identifying:

  • Who changed the configuration parameter value
  • When the configuration parameter was changed
  • Whether nonstandard settings were in effect in the past

Example:

dbadmin=> ALTER DATABASE sfdc SET EnableSSL = 1;
WARNING 4324:  Parameter EnableSSL will not take effect until database restart
ALTER DATABASE

dbadmin=> SELECT event_timestamp, user_name, parameter, value FROM configuration_changes WHERE parameter = 'EnableSSL';
        event_timestamp        | user_name | parameter | value
-------------------------------+-----------+-----------+-------
 2018-06-03 16:19:42.275319-04 | dbadmin   | EnableSSL | 1
(1 row)

Have Fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.