Delete database error:
pq: cannot drop the currently open database
Solutions:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='database-name' AND pid<>pg_backend_pid();
Kill the PID process
Then use super administrator to execute:
DROP DATABASE ‘database-name’
Read More:
- Unknown error (SQLite code 14): could not open database (How to Fix)
- Dm7 Dameng database dmrman reports an error OS_ pipe2_ conn_ Server open failed solution
- TypeError: drop() got an unexpected keyword argument ‘columns’
- Python + selenium drop-down list error message: element not interactive
- Solve the problem of VC 6.0 fatal error C1033: cannot open program database’.\debug\vc60.pdb’
- When Python Django creates a database, can’t open file ‘ manage.py ‘: [Errno 2] No such file or directory
- How to solve MySQL error 1049 (42000): unknown database ‘database’
- An error is reported when kettle connects Oracle database and MySQL database
- 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
- Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
- An error occurs when superstet connects to the Clickhouse database: error: could not load database driver: Clickhouse
- MySQL error: error 1010 (HY000) when deleting database
- Oracle can’t start the database due to deleting DBF file by mistake
- Error dropping database can’t rmdir
- The connection pool of SSM project database cannot be connected. The project can run normally and the database cannot be connected
- Change root to Oracle, and error: can’t open display: can’t open
- window.open () several ways to open windows
- The problem of MySQL database connection failure errno: 1049 error
- Error: the version of ZABBIX database does not match the current requirements
- Navicat premium essentials for Mac database settings