Connection not closed when PostgreSQL dropdb

Such as:

Steps to resolve:

1. SELECT * from pg_stat_activity where datname = ' lnarterydb '//query what sessions the library has

Query results will have two PID

2. SELECT pg_terminate_backend (PID); Break the session, roll back uncommitted things

For Pg_terminate_backend (PID) functions, refer to Here

http://blog.163.com/dazuiba_008/blog/static/3633498120131133328241/

This statement execution may be an error, then directly in the terminal with kill command, Kill-9 PID

3. At this point, you can dropdb xxx.

Connection not closed when PostgreSQL dropdb