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

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Merrilee

28 days ago

Option A seems a bit too simple. I doubt the changes would take effect as soon as the file is saved. There's probably some kind of reload or restart required.

upvoted 0 times

...

Gertude

1 months ago

I think Pamella is right, because restarting the server is usually required for configuration changes to take effect.

upvoted 0 times

...

1 months 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

Josefa

9 days ago

I think it's option A, the change will take effect as soon as postgresql.conf is saved.

upvoted 0 times

...

Chandra

1 months 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

...

Dong

1 months ago

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

upvoted 0 times

...