db backup & restore issue from odoo 15 to odoo 16

Question

i backup db from odoo 15 and restored it in odoo 16 ..
At the time of restoring it gives error as follows
Database restore error: operator does not exist: character varying ->> unknown LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
You cannot restore V 15 DB to V16 because there are many changes in the DB table structure between the versions.
You need to migrate your database
If you are using Enterprise Edition
Create an upgrade request to v16 migration
https://upgrade.odoo.com/ [1]
if you are using the community edition use Openupgrade scripts
https://www.odoo.com/documentation/16.0/administration/upgrade.html [2]
https://github.com/OCA/OpenUpgrade [3]
Regards

[1] https://upgrade.odoo.com/
[2] https://www.odoo.com/d

Dharma Pradhan · Answer

Thanks a million.
But in my case, i'm using docker for handling odoo and postgres

المنشورات ذات الصلة	الردود	أدوات العرض
what is database neutralize option in odoo16 while restoring database....??? تم الحل restoredb odoo16features	3 فبراير 25	13694
How to restore database from backup in V16 online ? backup restoredb odoo16features	6 يونيو 25	14673
Error overload or timeout when i restore database timeout restoredb overload odoo16features	1 أبريل 24	2109
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 مايو 25	2415
get all partners which are internal users or portal users odoo16 odoo16features	1 أبريل 25	3433

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!