POSTGRESQL-ESSENTIALS practice question 14 of 15
You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?
Full set: 71 questionsThe pgreloadconf() function is the correct and standard SQL-callable function used to signal the main PostgreSQL server process to reload its configuration files. This includes postgresql.conf, pghba.conf, and pgident.conf. Executing this function applies changes to configuration parameters that do not require a full server restart, thereby avoiding service interruption. This is equivalent to running pgctl reload on the command line or sending a SIGHUP signal to the postmaster process.
A. pgrestartconf(): This function does not exist in PostgreSQL. The name implies a restart, which is the action the user is explicitly trying to avoid.
C. reloadconfiguration(): This is not a standard, built-in PostgreSQL function. While descriptive, it does not follow the pg naming convention for many administrative functions.
D. refreshconfig(): This is not a valid PostgreSQL function for this purpose. The correct function for reloading configuration is pgreloadconf().
1. PostgreSQL 16 Documentation: Chapter 9. Functions and Operators, Section 9.27. Server Signaling Functions. The documentation explicitly lists pgreloadconf() and describes its purpose: "Signals the server to reload its configuration files."
Source: PostgreSQL Official Documentation, https://www.postgresql.org/docs/16/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE
2. PostgreSQL 16 Documentation: Chapter 20. Server Setup and Operation, Section 20.2. Managing the Server. This section details methods for reloading the configuration, stating: "To trigger a configuration file reload, you can either send the SIGHUP signal to the postmaster process, or run the SQL function pgreloadconf() from a SQL session..."
Source: PostgreSQL Official Documentation, https://www.postgresql.org/docs/16/managing-the-server.html
3. Carnegie Mellon University, Database Systems Courseware (15-445/645): Lecture #21 - Logging & Recovery. While discussing system administration, the lecture notes often refer to the need to reload configurations after changes, a task accomplished by pgctl reload or the equivalent SQL function pgreloadconf().
Source: CMU Database Group, https://15445.courses.cs.cmu.edu/fall2022/notes/21-recovery.pdf (See administrative commands section).
Keep practicing
Take the free POSTGRESQL-ESSENTIALS practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other POSTGRESQL-ESSENTIALS practice questions
- Question 1What is the purpose of the autovacuum parameter in PostgreSQL?
- Question 2Which psql meta-command is used to display all roles and their attributes?
- Question 3SERIAL and IDENTITY columns can be used to add an auto-incrementing column in a Postgres …
- Question 4You are connected to a PostgreSQL database. After executing a complex query an error mess…
- Question 5Which PostgreSQL configuration parameter controls the amount of memory used for sorting o…
- Question 6You want to set the maximum time to complete client authentication to 10 seconds. Which p…
