Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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
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:
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
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 10/28/15, 3:50 AM|
|Seen: 481 times|
|Last updated: 10/30/15, 11:55 AM|