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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Database startup / shutdown /restart

How to Enable/Disable autovacuum on PostgreSQL

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux