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 PGCES-02 Exam - Topic 6 Question 84 Discussion

You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?
C) This change will take effect by executing 'pg_ctl restart'.
A) This change will take effect as soon as postgresql.conf is saved.
B) This change will take effect by executing 'pg_ctl reload'.
D) This change will take effect after rebooting the OS, because the new option is recorded as an OS parameter.
E) This setting is invalid unless the change is made while postmaster is stopped.

PostgreSQL PGCES-02 Exam - 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:

0/2000 characters
Submit Cancel
Alease
7 months ago
Nah, it definitely needs a reload or restart.
upvoted 0 times
...
Virgina
7 months ago
Totally agree, that's the right way!
upvoted 0 times
...
Giovanna
7 months ago
It takes effect with 'pg_ctl reload'.
upvoted 0 times
...
Elden
7 months ago
Wait, are you sure it doesn't need a restart?
upvoted 0 times
...
Mirta
7 months ago
I thought it would apply immediately after saving.
upvoted 0 times
...
Keneth
8 months ago
I vaguely recall something about needing to restart the service for changes to take effect, but I'm not completely confident. Could it be C?
upvoted 0 times
...
Ressie
8 months ago
I feel like I read that some settings can take effect immediately, but this one seems more complicated. Maybe it's C?
upvoted 0 times
...
Maynard
8 months ago
I think we practiced a similar question where a reload was needed for certain settings. I might go with option B.
upvoted 0 times
...
Malcolm
8 months ago
I remember discussing how configuration changes in PostgreSQL usually require a reload or restart, but I'm not sure which one applies here.
upvoted 0 times
...
Vilma
9 months ago
This seems straightforward to me. The question states that the setting was added to the 'postgresql.conf' file, so it should take effect as soon as the file is saved. I'll go with option A.
upvoted 0 times
...
Gary
9 months ago
I'm a little confused by this question. Does the 'listen_addresses' setting get saved as an OS parameter or is it just a PostgreSQL configuration setting? I'm not sure if option D is correct or not.
upvoted 0 times
...
Bulah
9 months ago
Ah, I remember learning about this in class. The 'listen_addresses' setting is a dynamic parameter, so it should take effect after a 'pg_ctl reload' command. I'll choose option B.
upvoted 0 times
...
Muriel
9 months ago
Hmm, I'm a bit unsure about this one. I know some settings take effect immediately, but I can't remember if this is one of them. Maybe I should review the PostgreSQL documentation again.
upvoted 0 times
...
Natalie
9 months ago
I'm pretty sure this change requires a restart of the PostgreSQL server, so I'll go with option C.
upvoted 0 times
...
Merrilee
1 year 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
1 year ago
I prefer to play it safe and go with option C, 'pg_ctl restart' just to be sure.
upvoted 0 times
...
Dante
1 year ago
I agree, I always use 'pg_ctl reload' after making changes to postgresql.conf.
upvoted 0 times
...
Lavonda
1 year ago
I think option B is correct. We need to execute 'pg_ctl reload' for the changes to take effect.
upvoted 0 times
...
...
Gertude
1 year ago
I think Pamella is right, because restarting the server is usually required for configuration changes to take effect.
upvoted 0 times
...
Steffanie
1 year 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
1 year ago
User3: I believe the change will take effect by executing 'pg_ctl reload'.
upvoted 0 times
...
Earnestine
1 year ago
User2: I think the change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...
Tasia
1 year ago
User1: I know right, option E is hilarious!
upvoted 0 times
...
...
Pamella
1 year ago
I disagree, I believe the correct answer is C) This change will take effect by executing 'pg_ctl restart'.
upvoted 0 times
...
Yuette
1 year 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 year 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 year ago
I agree, it's option C, you need to restart the server for the changes to take effect.
upvoted 0 times
...
Dalene
1 year ago
I believe it's option C, the change will take effect by executing 'pg_ctl restart'.
upvoted 0 times
...
Josefa
1 year ago
I think it's option A, the change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...
...
Chandra
1 year 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 year ago
I think the answer is A) This change will take effect as soon as postgresql.conf is saved.
upvoted 0 times
...

Save Cancel