Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
11597 Lượt xem

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?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ

Ray Carnes Thank you. Helped me too. I restarted postgresql.

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 11 22
2499
0
thg 3 15
4722
0
thg 7 25
1405
2
thg 11 24
6163
2
thg 10 24
3132