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

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

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

PostgreSQL Database startup / shutdown /restart

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger