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

İlgili Gönderiler	Cevaplar	Görünümler
Database Error on Odoo.SH when restoring restoredb v15	0 Ara 21	3730
Odoo 14 database restore error Çözüldü restoredb databasebackup v14	3 Mar 22	10342
Problem- Restore Database on Odoo 8 restore restoredb databasebackup	3 Haz 16	8320
Database restoration issue when we restored data from odoo.sh database restoredb databasebackup restoration	0 Tem 23	3421
Odoo 15 database upgrade Error / unable to Restore odoo 14 database to odoo 15 backup restoredb odoo v15	0 Mar 22	2900

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!