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

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

関連投稿	返信	ビュー
Database Error on Odoo.SH when restoring restoredb v15	0 12月 21	3748
Odoo 14 database restore error 解決済 restoredb databasebackup v14	3 3月 22	10381
Problem- Restore Database on Odoo 8 restore restoredb databasebackup	3 6月 16	8333
Database restoration issue when we restored data from odoo.sh database restoredb databasebackup restoration	0 7月 23	3436
Odoo 15 database upgrade Error / unable to Restore odoo 14 database to odoo 15 backup restoredb odoo v15	0 3月 22	2904

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！