Skip to Content
This question has been flagged
restoredbpostgrestsql13odoo16features
2 Respostes
4143 Vistes
Avatar
Dharma Pradhan

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.

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best 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/

if you are using the community edition use Openupgrade scripts 

https://www.odoo.com/documentation/16.0/administration/upgrade.html

https://github.com/OCA/OpenUpgrade

Regards

Avatar
Descartar
Avatar
Dharma Pradhan
Autor Best Answer

Thanks a million.

But in my case, i'm using docker for handling odoo and postgres

Avatar
Descartar
Related Posts Respostes Vistes Activitat
what is database neutralize option in odoo16 while restoring database....??? Solved
restoredb odoo16features
Avatar
Avatar
Avatar
Avatar
3
de febr. 25
13961
How to restore database from backup in V16 online ?
backup restoredb odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
6
de juny 25
14985
Error overload or timeout when i restore database
timeout restoredb overload odoo16features
Avatar
Avatar
1
d’abr. 24
2244
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
d’ag. 25
2717
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
de maig 25
2687