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?

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

Alease

2 months ago

Nah, it definitely needs a reload or restart.

upvoted 0 times

...

Virgina

2 months ago

Totally agree, that's the right way!

upvoted 0 times

...

Giovanna

2 months ago

It takes effect with 'pg_ctl reload'.

upvoted 0 times

...

Elden

3 months ago

Wait, are you sure it doesn't need a restart?

upvoted 0 times

...

Mirta

3 months ago

I thought it would apply immediately after saving.

upvoted 0 times

...

Keneth

3 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

3 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

4 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

4 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

4 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

4 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

4 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

5 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

5 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

10 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