Hello,

as  postgres user I have executed to following commands to import the cloud database dump to migrate the Odoo installation to one of our servers:

dropdb odoo

createdb -O odoo odoo

psql odoo < /dump_lang.sql

But the import crashes with a number of errors:

....

ERROR:  null value in column "short_time_format" of relation "res_lang" violates not-null constraint

DETAIL:  Failing row contains (1, English (US), en_US, en, en, t, ltr, %m/%d/%Y, %H:%M:%S, null, 7, [3,0], ., ,, 1, 2022-06-29 17:39:34.171452, 1, 2023-03-24 00:13:17.176204).

CONTEXT:  COPY res_lang, line 1: "1 English (US) en_US en en t ltr %m/%d/%Y %H:%M:%S 7 [3,0] . , 1 2022-06-29 17:39:34.171452 1 2023-0..."

......

ERROR:  relation "public.base_registry_signaling" does not exist

LINE 1: SELECT pg_catalog.setval('public.base_registry_signaling', 6...

......

ERROR:  insert or update on table "website" violates foreign key constraint "website_default_lang_id_fkey"

DETAIL:  Key (default_lang_id)=(1) is not present in table "res_lang".

ERROR:  insert or update on table "website_lang_rel" violates foreign key constraint "website_lang_rel_lang_id_fkey"

DETAIL:  Key (lang_id)=(1) is not present in table "res_lang".

...

ERROR:  insert or update on table "website_visitor" violates foreign key constraint "website_visitor_lang_id_fkey"

DETAIL:  Key (lang_id)=(1) is not present in table "res_lang".

.....

My expectation was, that the dump contains all required information to migrate the installation. Obviously that is not the case.

Does anyone have an idea how to solve errors mentioned above?

Thanks for any help or suggestions,

Stefan