Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide 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
2 months 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
Freeman
30 days ago
I prefer to play it safe and go with option C, 'pg_ctl restart' just to be sure.
upvoted 0 times
...
Dante
1 months ago
I agree, I always use 'pg_ctl reload' after making changes to postgresql.conf.
upvoted 0 times
...
Lavonda
2 months ago
I think option B is correct. We need to execute 'pg_ctl reload' for the changes to take effect.
upvoted 0 times
...
...
Gertude
3 months ago
I think Pamella is right, because restarting the server is usually required for configuration changes to take effect.
upvoted 0 times
...
Steffanie
3 months ago
Haha, option E is the funniest one. 'This setting is invalid unless the change is made while postmaster is stopped.' That's a good one!
upvoted 0 times
Shenika
2 months ago
User3: I believe the change will take effect by executing 'pg_ctl reload'.
upvoted 0 times
...
Earnestine
2 months ago
User2: I think the change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...
Tasia
2 months ago
User1: I know right, option E is hilarious!
upvoted 0 times
...
...
Pamella
3 months ago
I disagree, I believe the correct answer is C) This change will take effect by executing 'pg_ctl restart'.
upvoted 0 times
...
Yuette
3 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
Lajuana
1 months ago
I'm not sure, but I think it might be option B, where you need to execute 'pg_ctl reload' for the changes to take effect.
upvoted 0 times
...
Dean
1 months ago
I agree, it's option C, you need to restart the server for the changes to take effect.
upvoted 0 times
...
Dalene
1 months ago
I believe it's option C, the change will take effect by executing 'pg_ctl restart'.
upvoted 0 times
...
Josefa
2 months ago
I think it's option A, the change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...
...
Chandra
3 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
3 months ago
I think the answer is A) This change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...

Save Cancel