I have created a new database, but cannot find a way to change the default database or switch databases. - Ubuntu Server 12.10 - I Created a new database using the "Manage Databases" link on the login page. - The only choices there are to duplicate or drop or backup or restore. - I cannot find any config file that controls the database name. - I need to keep data in the old database for a while.
The mistake of removing the "service" product is forcing me to move to a clean database. No modules can be added or changed after you remove "service" because it leaves a hole that generates errors.
Incidentally, the error with the deletion of the service product is in fact very simply to correct, you simply have to force an update of the
Product module, this will re-create the service product appropriately. We will change the error message to indicate so very soon, and for next version we'll make sure this error is prevented altogether.
As for renaming databases, there is no option in the database management interface to do so directly. If you're not familiar with PostgreSQL and the command-line of your operating system you can achieve this result by doing the following:
- Make a backup of your database (e.g. "foo") using the database manager
- Restore the backup of your database using the database manager, and choose the new name you wanted, e.g. "foo_new"
- After making sure that the freshly restore database works, you can finally drop "foo" using the database manager.
On the other hand if you're familiar with PostgreSQL you can use the pgAdmin interface to rename a database or execute the SQL command that @Andreas Brueckl mentioned, as a PostgreSQL super-user:
ALTER DATABASE foo RENAME TO foo_new;
You don't need to restart OpenERP after doing this, doing a simple logout + login in the new database should be enough.
Finally, you need to know that you won't see the database list on the login screen unless you have more than one database available.
PS: none of the above is specific to v7, by the way, the same applies to v6 or v6.1.
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
|Asked: 2/21/13, 11:51 PM|
|Seen: 9248 times|
|Last updated: 7/26/16, 11:54 AM|