Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
3 Vastaukset
2996 Näkymät

Dear Experts,

I recently formatted and reinstall Odoo 15 CE, before also it was v15 CE. I took a full back up and after full set up the odoo server I tried restoring database backup. I am getting this error,

Database restore error: Postgres subprocess ('/usr/bin/pg_restore', '--dbname=SLAD25622L', '--no-owner', '/tmp/tmpvdhpj708') error 1


I tried reading similar articles, but didn't get full understanding of resolving the issue. Can someone guide me resolve it completely? 


Cheers,

Chumley

Avatar
Hylkää
Paras vastaus

here is video reference  you should try this 


Avatar
Hylkää
Paras vastaus

If you receive an error that the database is in use, try to set the user to single user mode: USE master; GO ALTER DATABASE Database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE; Then try the restore with recovery command again. Also, make sure you are on the latest service pack or cumulative update.


Greeting,

Rachel Gomez

Avatar
Hylkää
Paras vastaus

In most cases this error raise due to version conflict i.e your odoo new odoo instance is Odoo 15.0+e-20220307 and the database you have is of different version.

This can be resolved by destroy the current odoo instance and reinstall the previous version of it, which I personally don't recommend.
Or

Restore the database from command line, how to do it, the answer is here

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
0
jouluk. 21
2702
3
maalisk. 22
8983
3
kesäk. 16
7238
0
heinäk. 23
2188
0
maalisk. 22
2175