nerdexam
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)
  • A
    3% (1)
  • C
    84% (32)
  • D
    8% (3)
  • E
    5% (2)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice