Skip to Content
Menu
This question has been flagged
3 Replies
5533 Zobrazenia

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
Zrušiť

Thank you Axel.

Best Answer

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
Zrušiť

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

Related Posts Replies Zobrazenia Aktivita
0
feb 21
1660
0
sep 18
3207
1
nov 16
8818
0
júl 25
277
1
jún 25
978