PostgreSQL_CE
PGCES-02 · Question #116
You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?
The correct answer is C. This change will take effect by executing "pg_ctl restart". See the full explanation below for the reasoning.
Question
You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?
Options
- AThis change will take effect as soon as postgresql.conf is saved.
- BThis change will take effect by executing "pg_ctl reload".
- CThis change will take effect by executing "pg_ctl restart".
- DThis change will take effect after rebooting the OS, because the new option is recorded as an
- EThis setting is invalid unless the change is made while postmaster is stopped.
How the community answered
(38 responses)- A3% (1)
- C84% (32)
- D8% (3)
- E5% (2)
Community Discussion
No community discussion yet for this question.