Database restoration error

Question

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

Md. Sajib Ali · Answer

here is video reference  you should try this

rachelgomez · Answer

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

Greeting,
Rachel Gomez

Bazcher and Co, LLP, Peshawar, Pakistan, Fazal Haleem · Answer

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 [1]

[1] https://www.youtube.com/watch?v=XrPURF5my9s

Related Posts	ตอบกลับ	มุมมอง
Database Error on Odoo.SH when restoring restoredb v15	0 ธ.ค. 21	4704
Odoo 14 database restore error แก้ไขแล้ว restoredb databasebackup v14	3 มี.ค. 22	11844
Problem- Restore Database on Odoo 8 restore restoredb databasebackup	3 มิ.ย. 16	9736
Odoo 15 database upgrade Error / unable to Restore odoo 14 database to odoo 15 backup restoredb odoo v15	1 ธ.ค. 25	4027
Database restoration issue when we restored data from odoo.sh database restoredb databasebackup restoration	0 ก.ค. 23	4408

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!