How can I change the name of my database. Can I do this without programming?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Projekte
- MRP
Diese Frage wurde gekennzeichnet
2
Antworten
16686
Ansichten
Hello, using postgresql: "ALTER DATABASE name RENAME TO newname" or you can duplicate the database with a new name in the database options, login screen.
Make sure you shut down the OpenERP server first if you use the ALTER DATABASE option.
Thank you very much for the information, I'l try this.
Hello, using postgresql: "ALTER DATABASE name RENAME TO newname"
If you change the database name, you have to rename its filestore too. So you can do the following:
1. Stop the Odoo server.
2.Log in to postgres and alter database name "ALTER DATABASE name RENAME TO newname"
3. Rename the filestore from old database name to new database name.
4. Restart Odoo server.
That should do it.
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
1
Juni 24
|
4764 | ||
|
1
März 15
|
8727 | ||
|
0
Juli 25
|
2275 | ||
|
2
Nov. 24
|
8469 | ||
|
2
Okt. 24
|
4827 |
... using postgresql: "ALTER DATABASE name RENAME TO newname"
NEVER DO THIS !!!
I try it and reach serious pb with server after that : no one of existing databases correctly load and work !
Seems that theme management if broken, at least...
Use only the web function "duplicate" or "backup" then "restore to an other name