CODEWITHSUNDEEP
databasepostgresqlubuntuconnection
juztcode
juztcode

Reputation: 1345

disconnecting pgadmin's connection via bash

after registering the user in the postgres database(in ubuntu) we can execute some basic command like dropdb, createdb directly from the terminal to alter the database.

I basically was creating a shell script to renew the database. So, I thought doing this would suffice:

dropdb veganary_test && createdb veganary_test

as always, I was wrong. Since I had multiple connections to the database, db wouldn't drop. I also tried this:

    psql <database_name> -c "SELECT pg_terminate_backend(pg_stat_activity.pid)
              FROM pg_stat_activity
              WHERE pg_stat_activity.datname = '<database_name>'
              AND pid <> pg_backend_pid();"

and, yet it wasn't successful on disrupting pgadmin's connection. How can I disconnect every user connected to my <database_name> database from the terminal?(bash)

Upvotes: 1

Views: 114

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246013

Upgrade to PostgreSQL v13 and use

dropdb --force veganary_test

Upvotes: 2

Related Questions