İçereği Atla
Menü
Bu soru işaretlendi
3 Cevaplar
5529 Görünümler

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

Avatar
Vazgeç

Thank you Axel.

En İyi Yanı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

Avatar
Vazgeç

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
0
Şub 21
1658
0
Eyl 18
3206
1
Kas 16
8807
0
Tem 25
261
1
Haz 25
961