Can't Drop Database

Question

when I try from base management it says:

Could not drop database !

and when I try to drop via terminal:

dropdb: database removal failed: ERROR:  database "database" is being accessed by other users
DETAIL:  There are 4 other session(s) using the database.

I can drop other databases, but not the one I need to drop

any other possibilities?

Ray Carnes · Accepted Answer

Restarting the server may not fix this. If a user is logged into PostgreSQL, then restarting Odoo won't disconnect them. A better answer would be to restart PostgreSQL and try again.

Ludo - 21South · Answer

Restart the service ( /etc/init.d/openerp-server restart) and immediately try again. If you are going to drop the database from commandline, then you can completely stop the OpenERP server and then try again.

관련 게시물	답글	화면
How do you drop a database from terminal on Windows? 해결 완료 database drop	1 11월 22	2648
Cannot drop database through web client and terminal database drop	0 3월 15	5003
Database disappeared from list after activating Google Oauth for administrator database	0 7월 25	1603
Setup Odoo with specific database database	2 11월 24	6739
database locked database	2 10월 24	3630

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!