Sample Exam Questions

From the objective of OSS-DB Exam Silver
- Operation and Management - configuration file

Sample Question

1.35

Which two of the following parameters you set in postgresql.conf, will require a server restart to reflect the changes.

  1. port
  2. max_connections
  3. log_connections
  4. log_line_ prefix
  5. search_path

※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04

Answer and Explanation

In postgresql.conf you can set various parameters that control the operation of the server. Many parameters are changed by reloading the file with pg_ctl reload, but some parameter change requires restarting the server such as pg_ctl restart.

Of the parameters discussed in the example, changing the port (the port number monitored by the server) and max_connections (the maximum number of simultaneous connections to the server) requires restarting the server.

log_connections (setting whether to keep client connection attempts in the log) or log_line_ prefix (output format of logs) change more than just reload.

If search_path (the default schema search path) also changes its setting, the new setting become effective for subsequent client connections.

Therefore, the correct answers are A and B.