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

When am trying to drop database getting this "DETAIL: There are 5 other sessions using the database."

So should drop database without stopping either postgres server or odoo server

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

Thank you Axel.

Câu trả lời hay nhất

If you need to do it in psql or using a postgresql client you could issue this query to stop those sessions:

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'db_name' AND pid != pg_backend_pid();

Change db_name for your target database to drop

But Odoo itself do this if you drop the database through Odoo database manager ui accesible at:

http://localhost:8069/web/database/manager#action=database_manager

In the menu drop, select the target database to drop, type the instance admin password and clic drop button or press enter.

Change localhost:8069 in the previous url to match your Odoo instance url

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

If works for you then you need to vote and accept the answer

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 2 21
1698
0
thg 9 18
3264
1
thg 11 16
8895
1
thg 7 25
439
1
thg 6 25
1059