PostgreSQL Exam PGCES-02 Topic 6 Question 84 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 84
Topic #: 6

[All PGCES-02 Questions]

You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?

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 OS parameter.

EThis setting is invalid unless the change is made while postmaster is stopped.

Show Suggested Answer

Suggested Answer: C

by Veronika at Apr 08, 2025, 08:46 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Hmm, I'm not sure. I feel like it might be option C, where you need to restart the server for the changes to take effect.

upvoted 0 times

...

4 days ago

I think option B is the correct answer. The 'pg_ctl reload' command should reload the configuration file and apply the new setting.

upvoted 0 times

...

6 days ago

I think the answer is A) This change will take effect as soon as postgresql.conf is saved.

upvoted 0 times

...