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 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

by Doyle at Aug 08, 2024, 05:19 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Cathrine
2 months 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
2 months 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
Sharee
18 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
...
Filiberto
21 days ago
E) pg_ctl -s stop
upvoted 0 times
...
Noemi
22 days ago
D) pg_ctl -m wait stop
upvoted 0 times
...
Fletcher
24 days ago
C) pg_ctl -m immediate stop
upvoted 0 times
...
Billy
1 months ago
B) pg_ctl -m fast stop
upvoted 0 times
...
Arlette
1 months ago
A) pg_ctl stop
upvoted 0 times
...
...
Twila
3 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
2 months ago
Let's go with option D then, it seems like the best option.
upvoted 0 times
...
Darrin
2 months ago
I agree, option D seems like the safer choice.
upvoted 0 times
...
Cortney
2 months ago
I think 'immediate' stop is too abrupt too. I would go with option D.
upvoted 0 times
...
...
Reita
3 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
2 months ago
Yes, I think so too. 'Fast' does imply a quick shutdown after all the clients have disconnected.
upvoted 0 times
...
Gracie
2 months ago
I agree, option B does seem like the most appropriate choice in this situation.
upvoted 0 times
...
...
Madelyn
3 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
3 months ago
I agree with Kerry, using immediate stop ensures the postmaster shuts down right away.
upvoted 0 times
...
Kerry
4 months ago
I think the correct command is C) pg_ctl -m immediate stop.
upvoted 0 times
...

Save Cancel