How to delete postgresql9.6 database on centos7?

Question

I'm am using postgresql 9.6; while deleting my mrt_210119 database, getting an error like "ERROR: database "mrt_210119" is being accessed by other users DETAIL: There is 1 other session using the database"

Kandy · Accepted Answer · 2019-01-23 11:19:22Z

1

you cannot drop a database while clients are connected to it. then also, if you want to drop database than you need some sql statement to run which required superuser and database owner privileges .

first make sure no one connect to database further any more by using below update statement.

UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'mydb';`

Below select statement terminate all current connection which is connected to database.

 SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'mydb';

than drop statement-

DROP DATABASE mydb;

answered Jan 23, 2019 at 11:19

Kandy

6739 silver badges22 bronze badges

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

Comments

nasdenkov · Accepted Answer · 2019-01-23 11:03:38Z

1

If you have an active connection to your database, close it. If you don't, try pkill postgres and then delete.

answered Jan 23, 2019 at 11:03

nasdenkov

5410 bronze badges

2 Comments

Zakir Hossain Over a year ago

#nasdenkov - where i execute the 'pkill postgres' command ? do you clear it ?

nasdenkov Over a year ago

In the terminal of the machine that is hosting the database service.

Collectives™ on Stack Overflow

How to delete postgresql9.6 database on centos7?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related