docker icon indicating copy to clipboard operation
docker copied to clipboard

Published 20 hours ago • verified publisher icon odoo

Database retoring odoo 11 CE

Open guidev224 opened this issue 4 years ago • 1 comments

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".

guidev224 avatar Jun 25 '21 14:06 guidev224

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

arabkhemar avatar Oct 08 '21 11:10 arabkhemar