MENU
You want to gracefully terminate a user's connection to the database. Which function should you use?
Suggested Answer: B
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
LA
Lajuana
3 days ago
B is the right choice, no doubt!
JA
Jaleesa
8 days ago
I thought it was A) pg_kill_backend(pid)?
SA
Sage
13 days ago
Definitely B) pg_terminate_backend(pid) for a graceful exit.
LU
Luisa
18 days ago
I agree with Beula, B is the right choice!
RE
Rex
23 days ago
Wait, is there really a function called pg_disconnect_backend(pid)? Sounds weird.
LE
Leontine
29 days ago
No way, it's C) pg_cancel_backend(pid) for sure!
RU
Ruth
1 month ago
I thought it was A) pg_kill_backend(pid)?
BE
Beula
1 month ago
Definitely B) pg_terminate_backend(pid) for a graceful exit.
MI
Mignon
1 month ago
I can't recall if pg_disconnect_backend is even a real function. I should probably go with pg_terminate_backend, though.
IR
Ira
2 months ago
I feel like pg_kill_backend is more about forcefully killing the connection, so it can't be that one.
EA
Earleen
2 months ago
I remember practicing with similar questions, and pg_cancel_backend sounds familiar, but I don't think it actually terminates the connection.
AN
Anika
2 months ago
I think it might be pg_terminate_backend, but I'm not entirely sure if that's the right one for graceful termination.