How can I delete databases when 'drop' from Manage Databases says the operation was successful but the database is still there?

Question

I have recently migrated my company openerp 7 data to a new server (same open ERP, apps & modules etc.).  This has taken me a few attempts and I have created a couple of 'test' databases to check that all was restored successfully.

I am now trying to delete the tests databases using the 'Drop' function in the Manage Database window.  However, despite getting a message to say it was successful, the databases are all still there, leaving my users to having to select one.
This is not ideal as it w

Papirkriger.no · Accepted Answer

You're not specifying which OS your odoo-server (or dedicated postgresql-server) runs on, so I'm gonna assume it's Ubuntu Linux or equivalent.
1. SSH inn to your server.
2. Change user to your database-user (name of database-user was set during initial setup of system):
*sudo su postgres*
3. Start Psql:
*psql*
4. List available databases:
*\l*
5. Drop database:
*drop database your_db_name_to_remove;*
5.1. If you get a message something like "Unable to drop database. DETAIL: There are 5 other ses

Ahmed Saber · Answer

close the application and open psql from terminal
$ psql $ drop database "your_database_name";

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!