view and kill postgresql connections to database

/* view connections */
SELECT * FROM pg_stat_activity;

/*-— Kill connections*/
SELECT
    pg_terminate_backend(pid)
FROM
    pg_stat_activity
WHERE
    -- don't kill my own connection!
    pid != pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'clinical_data';

/* kill a specific connection */     
select pg_terminate_backend(13337)

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

kill all connection postgres postgresql kill idle connections postgresql kill connections to database psql kill connections to database terminate connections postgresql postgresql kill all idle connections postgresql close all connections to database kill all connection postgresql kill active connections postgres close all connections to database postgres close all database connections psql kill all postgres connections how to kill all idle connections in postgres kill active postgres connections how to kill postgres connections postgresql stop all connections kill all connection to database postgres for specfic database postgres kill all idle connections postgres stop all database connections postgres stop all connections Kill connections to SQL database postgres close all postgres connections postgres close connections to database postgres close all connections query postgres server close all connections close all active connections postgres database psql kill all connections to database psql kill all connections kill postgres connection psql close all connections to database kill all database connections postgres postgres ubuntu stop all connections to database destroy postgres session There are 8 other sessions using the database. how to kill connection postgresql disconnect all database pgadmin rails DETAIL: There are 2 other sessions using the database. kill connection postgresql postgres kill connections There are 2 other sessions using the database kill connection psql disconnect all users from postgres database postgresql kill connection kill postgres connections s being accessed by other users DETAIL: There is 1 other session using the database. terminate connections postgres drop active postreg session postgres DETAIL: There are 2 other sessions using the database. pgadmin close all sessions postgresql close all sessions postgres killing connections kill all connections to a database postgres postgres another session uses database there is 1 other session using the database. postgres drop all connections to database postgres psql close all connections postgres stop sessions using database is being accessed by other users DETAIL: There is 1 other session using the database. close all active connections postgres how to drop all connection to psql postgres drop all connections postgres kick users out of database postgresql force close all connections postgresql kill connections postgresql close all connections kill database connection mac kill connections to postgres database how to kill second pgadmin kill connection by username postregsql close postgres connection postgres kill database sessions close all postgres open connections psql kill multiple connections psql kill connectison pgadmin kill sessions for database postgres kill connection postgressdrop connection to all clients pg close user connections There are 3 other sessions using the database. kill all pg server connections close all sessions on psql There are 5 other sessions using the database. There are 2 other sessions using the database. other sessions using the database DETAIL: There are 2 other sessions using the database. pgadmin other sessions of database There are 4 other sessions using the database. DETAIL: There is 1 other session using the database. postgresql close connections postgres delete connections postgres end connection in table close all connections to postgres database there are 9 other sessions running this database l: there are 3 other sessions using the database. close postgres connections linux pg kill session there is one other session using the database postgres detail there is 1 other session using the database detail there is 1 other session using the database. postgres what happens when you kill connection to postgres database There are other sessions using the database. how to close all connections in postgresql postgres delete all connections by pid psql kill all sessions stop connection with postresql does postgresql force ddisconenct terminate all connections postgres close all sessions postgresql terminate connection postgres postgres close connections kill db connections on terminal postgres postgres stop sessions close connections postgres how to close all existing connections on a database postgres postgres kill all connections close all connections to postrges database pgadmin quit other sessions using the database postgres disconnect users close all postgres connections for my user postgres close all connections close connections psql drop connections psql psql close connections postgres remove hung session postgres other sessions using the database psql close all session psql close sessions postgresql force disconnect all other sessions using the database. close connection postgresql stop sessions postgresql postgres flush connections postgres close open connection postgres force connection close postgres end all connections postgresql release connections kill connection postgres There is 1 other session using the database. pgadmin there are 2 other sessions using the database There is 1 other session using the database close session postgresql command line postgresql delete sessions view and kill postgresql connections to database

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example