Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
3 Antwoorden
5514 Weergaven

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
Annuleer

Thank you Axel.

Beste antwoord

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
Annuleer

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

Gerelateerde posts Antwoorden Weergaven Activiteit
0
feb. 21
1647
0
sep. 18
3195
1
nov. 16
8763
0
jul. 25
211
1
jun. 25
924