Difference Between Pg_Cancel_Backend() And Pg_Terminate_Backend() In Postgresql
pg_cancel_backend():-
Cancels the running query ,Cancel a backend's current query
pg_terminate_backend():-
Terminates the entire process and thus the database connection,terminate a backend A connection which is idle or idle in transaction does not have a current query to cancel, but it has a backend process which can be terminated.
Comments
Post a Comment