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.

Apg_ctl stop

Bpg_ctl -m fast stop

Cpg_ctl -m immediate stop

Dpg_ctl -m wait stop

Epg_ctl -s stop

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

Reita

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

...

Madelyn

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

14 days ago

I agree with Kerry, using immediate stop ensures the postmaster shuts down right away.

upvoted 0 times

...

Kerry

25 days ago

I think the correct command is C) pg_ctl -m immediate stop.

upvoted 0 times

...