Restauration d'un template Odoo après un crash

Sur un serveur de test :

Tout d'abord restaurer un ancien backup de la database sur un autre serveur :

Ensuite exporter en CSV juste la table :

copy public.ir_ui_view TO '/tmp/ui_view.csv' DELIMITER ',' CSV HEADER;

Recréer une 2ème table :

CREATE TABLE public.ir_ui_view2 (
    id integer NOT NULL,
    name character varying NOT NULL,
    model character varying,
    key character varying,
    priority integer NOT NULL,
    type character varying,
    arch_db text,
    arch_fs character varying,
    inherit_id integer,
    field_parent character varying,
    mode character varying NOT NULL,
    active boolean,
    create_uid integer,
    create_date timestamp without time zone,
    write_uid integer,
    write_date timestamp without time zone,
    website_meta_title character varying,
    website_meta_description text,
    website_meta_keywords character varying,
    website_meta_og_img character varying,
    customize_show boolean,
    website_id integer,
    theme_template_id integer,
    CONSTRAINT ir_ui_view_inheritance_mode CHECK ((((mode)::text <> 'extension'::text) OR (inherit_id IS NOT NULL))),
    CONSTRAINT ir_ui_view_qweb_required_key CHECK ((((type)::text <> 'qweb'::text) OR (key IS NOT NULL)))
);

Sur le serveur de PRODUCTION :

copy public.ir_ui_view2 FROM '/tmp/ui_view.csv' DELIMITER ',' CSV HEADER;

UPDATE public.ir_ui_view
SET name = public.ir_ui_view2.name,
    model = public.ir_ui_view2.model,
    key = public.ir_ui_view2.key,
    priority = public.ir_ui_view2.priority,
    type = public.ir_ui_view2.type,
    arch_db = public.ir_ui_view2.arch_db,
    arch_fs = public.ir_ui_view2.arch_fs,
    inherit_id = public.ir_ui_view2.inherit_id,
    field_parent = public.ir_ui_view2.field_parent,
    mode = public.ir_ui_view2.mode,
    active = public.ir_ui_view2.active,
    website_meta_title = public.ir_ui_view2.website_meta_title,
    website_meta_description = public.ir_ui_view2.website_meta_description,
    website_meta_keywords = public.ir_ui_view2.website_meta_keywords,
    customize_show = public.ir_ui_view2.customize_show,
    website_id = public.ir_ui_view2.website_id,
    theme_template_id = public.ir_ui_view2.theme_template_id
FROM public.ir_ui_view2
WHERE public.ir_ui_view.id = public.ir_ui_view2.id;