How to drop database which has some sessions open

Question

I am trying to drop a database using the following command and I get an error

DROP DATABASE IF EXISTS mydb;
There are 5 other sessions using the database.

Is there any sql statement/sequence of queries which which drops database killing all the open sessions? I can only use commnand line.

I tried SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'mydb'; and also tried restarting postgres service which ideally should have worked but it did not.

Had you tried this question's answers.

Jaydeep Mor
– Jaydeep Mor

2019-12-19 08:30:32 +00:00
Commented Dec 19, 2019 at 8:30 — Jaydeep Mor
– Jaydeep Mor, Commented Dec 19, 2019 at 8:30

codec · Accepted Answer · 2016-11-19 06:12:50Z

1

OK the followoing command worked for me great

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'mydb' AND pid <> pg_backend_pid();

answered Nov 19, 2016 at 6:12

codec

8,96429 gold badges88 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to drop database which has some sessions open

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related