From the objective of OSS-DB Exam Silver
- Operation and Management - configuration file (postgresql.conf)
Sample Question
1.19
Regarding postgresql.conf, choose the most appropriate description.
- After modifying the file, many parameters are reflected by execution of pg_ctl reload, but some of the parameters are effective immediately by file modification.
- Multiple parameters can be set on a single line by separating them with a semicolon (;).
- When you end the line with a backslash (\), it becomes a continuation line, and parameters can be set across multiple lines.
- You can place # at the beginning of a line to make that line a comment line, or you can put # in the middle of a line and make a description on the right side of it as a comment.
- By executing ALTER SYSTEM, the contents are rewritten.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
Answer and Explanation
postgresql.conf file contains a variety of settings for the PostgreSQL database cluster. After changing the configuration file, there are parameters that become effective by reloading the file and parameters that require restarting the database.
The former, for example pg_ctl reload, the latter is enabled by, for example, pg_ctl restart.
Parameters can be only one set per line.
# is a symbol that is used to comment, than the right-hand side it becomes a comment. If you put the beginning of the line, the entire line is a comment line.
But from version 9.4 ALTER SYSTEM command has been added, change of this is written to a file called postgresql.auto.conf, set the contents of the postgresql.auto.conf takes precedence over postgresql.conf.
Therefore, the correct answer is D.