Skip ke Konten
Pertanyaan ini telah diberikan tanda
4 Replies
26343 Tampilan
Avatar
igorrr

I use Odoo 9. When i restore database from backup it says Database restore error:

and nothing more. Also there is no errors neither in odoo nor in postgres logs.
How can i find problem in such conditions ?

Avatar
Buang
Avatar
Yogendrasinh Chavda
Jawaban Terbai

Hello Igorrr,

Are you restoring a database backup from odoo web view? if you still getting the error to restore the backup then restores the database using a command from the terminal.

E.g:
First, create new database by 

:~$ createdb new_database_name -U username

Then Restore your database into the newly created database using below command.

:~$ pg_restore -d new_database_name -U database_username  your_database_backup_path.dump

      Or

:~$ psql -d new_database_name -f  your_database_backup_path.dump

     Or

:~$ psql -d new_database_name -f  your_database_backup_path.sql

Thanks

Avatar
Buang
Avatar
Md. Sajib Ali
Jawaban Terbai

here is video reference  you should try this 


Avatar
Buang
Avatar
Sam fayad
Jawaban Terbai

Hi, I Had the same issue
For me, it been solved by upgrade the python version

My Odoo Version : 16
My Postgress: 15

Python upgraded : 3.7.0 --> 3.11.*

Avatar
Buang
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Jawaban Terbai

Hi Igorrr,

You can find more information in the Odoo logfile, which is usually under /var/log/your-odoo/your-file.log.
Usually this error is coming from the fact that your server has run out of RAM or storage, which causes the Odoo to stop the restore and you'll get an empty warning. 
The following issue (and there is a workaround for now) will most likely be relevant for you: https://github.com/odoo/odoo/pull/17663 

Regards,
Yenthe


Avatar
Buang