Restoration of PostgreSQL database 'database.backup' and use it in odoo

Question

I have a database issued of PostgreSQL 'database.backup' (700 Mo), I want to use it in odoo 8. I've tried this:
-1 I've created a new database in PGadminIII and I restored 'database.backup'  directly, but it didnt appear in odoo interface so I can select it.
-2 I've created a new database in odoo (in the interface, database manager), and I've restored 'database.backup' in PGadminIII. but I've encountered a problem, when I want to install a new module this error appears:
'Integrity Error
The oper

Islam ZOUAR · Accepted Answer

I found what was the problem, I made 2 mistakes:
-The 1st was to not give the same name to the new database created as the name of the file
-The 2nd was to not select the owner of the new database, it should be the same as the configuration of odoo, in my case 'openerp'.
So to restore a database in odoo, you can follow this steps:
-Create a new database in postgreSQL and give it the same name as the file's name (file name = 'database.backup', new  database base name = 'database').
-Select the ow

Xavier Brochard · Answer

What did you use to make the backup ?
Assuming it was done through Postgresql utilities, you should be able to restore it on a copy of the original database. Go on Odoo's Database Manager, duplicate the original database, then restore the backup through Postgresql.

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!