How to delete a database in pgadmin

Question

When i try to create other database with the name "eCommerce" in pgadmin 4 this message appears

ERROR: source database "template1" is being accessed by other users DETAIL: There are 2 other sessions using the database.

I try to delete the others databases but is not working and appears

ERROR: cannot drop a template database

What should i do?

Stop the two other programs currently using the database and retry? — Elliott Frisch, Nov 16 '19 at 20:31
I try to stop the other database but is not working. I m creating database like = "create" > " Database " , the name "eCommerce" and when i click to "save" the message appears. — Sabrina MK, Nov 16 '19 at 23:23

score 37 · Answer 1 · answered Nov 18 '20 at 08:10

37

It's impossible to drop a database in pgAdmin4 by right-clicking on it and selecting Delete/Drop from the context menu. Because as soon as you right-click on it pgAdmin opens a connection to that database.

But there is another way in pgAdmin4:

Close connections to the databases you would like to delete by right-clicking on it and selecting "Disconnect database..."
Left-click on "Databases" (One up in the hierarchy: The folder that contains all your databases)
Select tab "Properties" on the right hand side
There you can select all your databases you would like to delete and click on the trashcan icon:

answered Nov 18 '20 at 08:10

softi

491
1
4
3

5

But i cannot select the required db. – Madhawa Priyashantha Jan 07 '21 at 12:35
1

I just discovered this "feature" of pgadmin34. Pretty stupid that Delete/Drop exists on the right-click menu at all, given it is broken! – Bernd Wechner May 10 '21 at 03:30

score 11 · Accepted Answer · answered Nov 16 '19 at 22:26

You simply need to terminate the connections before deleting the database :)

    //Terminate all Connections on HostDB
     SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'Database_you_want_to_delete';

After that deleting shall work without an further problems.

Edit: For further information please take a look at this thread: Kill a postgresql session/connection

Muluken Getachew · Answer 3 · 2021-09-05T09:43:44.073

3

The Simplest Solution, I think, is closing opened tabs

simply closing any opened tabs related to that database in pgAdmin solves it.

In your case, 2 processes "might" be translated as at most two tabs in pgAdmin related to that database!

edited Sep 05 '21 at 09:43

answered Feb 10 '21 at 14:53

Muluken Getachew

858
6
8

score 2 · Answer 4 · answered Mar 04 '22 at 10:10

2

You can not drop the currently open database. Run query DROP DATABASE db_name; in Query Tool from another database.

answered Mar 04 '22 at 10:10

dodiws

46
3

score 0 · Answer 5 · answered May 25 '22 at 21:57

Using pgAdmin, I followed @softi's solution but tweaked it a little bit and it worked

First, Close connections to the database(s) you would like to delete by right-clicking on it and selecting "Disconnect database..."

Left-click on "Databases" (One up in the hierarchy: The folder that contains all your databases)

Select "Dashboard" tab on the right hand side and terminate the session(s) of the database(s) you want to delete/drop

Then go to the "Properties" tab (next to the Dashboard tab), then select the database(s) you would like to delete and click on the trashcan icon above the list

How to delete a database in pgadmin

5 Answers5

Linked