Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Postgres Database Patch

How to Enable/Disable autovacuum on PostgreSQL

PostgreSQL Enterprise Manager - PEM Monitoring Tools