How to Create new database from postgresql v7 on shell

Question

I'm trying to create new database from postgres, because I am no longer able to do it from user interface. for that :

I switched to openerp user, so as to be the owner of the new database freshly created.

I taped : /*createdb dbname - t template1*/

I'm getting the new database, but I cannot access it, with /*login : admin / pass : admin */( i did a select login,password from res_users to get this login's informations) , it tells me that there is no external_id : base.change_password

Is there

Francesco OpenCode · Answer

*createdb* is a postgresql tool to create a /new EMPTY/ database. When you create a new database with Odoo, it imports modules and create the relative tables. You can't create a new Odoo database only with createdb. With createdb you can only create an empty db to import a dump of another db.

Gerelateerde posts	Antwoorden	Weergaven
Restore a database (openerpv7) database postgresql v7 restore	2 mrt. 15	11508
How to select a different database on login screen Opgelost database v7	4 jul. 24	33918
Database Migration database postgresql	1 jul. 23	7292
Cannot create new database database create postgresql odoo Odoo13.0	2 feb. 21	8838
v7 - How to "query-insert" a stage change in a task journal ? postgresql v7	4 nov. 16	4824

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!