Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
3 Antwoorden
3152 Weergaven

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
Annuleer
Beste antwoord

here is video reference  you should try this 


Avatar
Annuleer
Beste antwoord

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
Annuleer
Beste antwoord

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
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
0
dec. 21
2833
3
mrt. 22
9171
3
jun. 16
7362
0
jul. 23
2378
0
mrt. 22
2280