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

PostgreSQL Exam PGCES-02 Topic 11 Question 68 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 68
Topic #: 11
[All PGCES-02 Questions]

Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.

Show Suggested Answer Hide Answer
Suggested Answer: A, D

Contribute your Thoughts:

Cathrine
12 days ago
I'm torn between B and D. 'Wait' seems like a good idea, but 'fast' is probably the most efficient way to shut it down cleanly. Decisions, decisions...
upvoted 0 times
...
Lauran
13 days ago
Haha, E 'silent' stop? Is that like the PostgreSQL version of the 'Vulcan nerve pinch'? I'm going with B, just to be on the safe side.
upvoted 0 times
...
Twila
1 months ago
Hmm, I'm not sure about this one. 'Immediate' stop sounds a bit too abrupt, don't you think? I'm leaning towards B or D.
upvoted 0 times
Peggie
1 days ago
Let's go with option D then, it seems like the best option.
upvoted 0 times
...
Darrin
18 days ago
I agree, option D seems like the safer choice.
upvoted 0 times
...
Cortney
23 days ago
I think 'immediate' stop is too abrupt too. I would go with option D.
upvoted 0 times
...
...
Reita
2 months ago
I think option B looks like the best choice here. It's the only one that specifically mentions 'fast' which seems like the right approach after all the clients have disconnected.
upvoted 0 times
Charlie
13 days ago
Yes, I think so too. 'Fast' does imply a quick shutdown after all the clients have disconnected.
upvoted 0 times
...
Gracie
20 days ago
I agree, option B does seem like the most appropriate choice in this situation.
upvoted 0 times
...
...
Madelyn
2 months ago
I'm not sure, but I think D) pg_ctl -m wait stop might also work if we want to wait for all clients to disconnect first.
upvoted 0 times
...
Idella
2 months ago
I agree with Kerry, using immediate stop ensures the postmaster shuts down right away.
upvoted 0 times
...
Kerry
2 months ago
I think the correct command is C) pg_ctl -m immediate stop.
upvoted 0 times
...

Save Cancel