search

odoo / docker

Other
932 stars 1.52k forks source link

Database retoring odoo 11 CE #377

Open guidev224 opened 3 years ago

guidev224 commented 3 years ago

Hello, I have an odoo 11ce instance running on a VPS and I use the auto_backup module to backup the database. When I try to restore the database on my local dockerized odoo I get weird things:

  1. Sometime the restoring succeeds but the user table (res.users) does not contain all data. It only contains default data. It is the same case for res.partner. But all other tables contains their data
  2. The second attempt I got this error: 
    psycopg2.IntegrityError: insert or update on table "ir_model" violates foreign key constraint "ir_model_write_uid_fkey"
DETAIL:  Key (write_uid)=(19) is not present in table "res_users".
arabkhemar commented 2 years ago

@guidev224 export your database from odoo database manager (make sure to include filestore!) then import it on your local env.