MENU
You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?
Suggested Answer: C
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
AL
Alease
10 months ago
Nah, it definitely needs a reload or restart.
VI
Virgina
10 months ago
Totally agree, that's the right way!
GI
Giovanna
10 months ago
It takes effect with 'pg_ctl reload'.
EL
Elden
10 months ago
Wait, are you sure it doesn't need a restart?
MI
Mirta
10 months ago
I thought it would apply immediately after saving.
KE
Keneth
11 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?
RE
Ressie
11 months ago
I feel like I read that some settings can take effect immediately, but this one seems more complicated. Maybe it's C?
MA
Maynard
11 months ago
I think we practiced a similar question where a reload was needed for certain settings. I might go with option B.
MA
Malcolm
11 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.
VI
Vilma
12 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.
GA
Gary
12 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.
BU
Bulah
12 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.
MU
Muriel
1 year 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.
NA
Natalie
1 year ago
I'm pretty sure this change requires a restart of the PostgreSQL server, so I'll go with option C.
ME
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.
FR
Freeman
1 year ago
I prefer to play it safe and go with option C, 'pg_ctl restart' just to be sure.
DA
Dante
1 year ago
I agree, I always use 'pg_ctl reload' after making changes to postgresql.conf.
LA
Lavonda
1 year ago
I think option B is correct. We need to execute 'pg_ctl reload' for the changes to take effect.
GE
Gertude
1 year ago
I think Pamella is right, because restarting the server is usually required for configuration changes to take effect.
ST
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!
SH
Shenika
1 year ago
User3: I believe the change will take effect by executing 'pg_ctl reload'.
EA
Earnestine
1 year ago
User2: I think the change will take effect as soon as postgresql.conf is saved.
TA
Tasia
1 year ago
User1: I know right, option E is hilarious!
PA
Pamella
1 year ago
I disagree, I believe the correct answer is C) This change will take effect by executing 'pg_ctl restart'.
YU
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.
LA
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.
DE
Dean
1 year ago
I agree, it's option C, you need to restart the server for the changes to take effect.
DA
Dalene
1 year ago
I believe it's option C, the change will take effect by executing 'pg_ctl restart'.
JO
Josefa
1 year ago
I think it's option A, the change will take effect as soon as postgresql.conf is saved.
CH
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.
DO
Dong
1 year ago
I think the answer is A) This change will take effect as soon as postgresql.conf is saved.