Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Problem- Restore Database on Odoo 8

By
Saad Bin Saif
on 6/15/16, 5:48 AM 387 views

I am using odoo 8 for trial for my organization on Ubuntu 14.04 Desktop (64 bit). I need to restore a database (zipped including files) which size is 3.9 GB. When I try to restore from GUI (database manager of odoo) , after 10 minutes, it shows "Restore Failed". PostgreSQL version is 9.5.3.

0
Saad Bin Saif
On 6/21/16, 11:35 PM

 


0
Dilip Dabhi
On 6/21/16, 8:55 AM

You can restore database from Terminal.

Steps:

1. sudo su postgres
2.createdb database_name --owner=odoo-user --encoding=utf8;

3.psql database_name < databasefile.sql ( .sql file of database backup )


0
nishad
On 6/21/16, 6:52 AM

I do noted this issue while restoring Database with size more than 2 GB.

So the alternative for this is just restore it from back-end using the following steps

a) Create a database from the command line ( createdb newdatabase)

b) Alter database owner from postgresql to Odoo

c) Restore DB from raw file ( cat filename | psql newdatabase )

Eg:- cat pg_dump.sql | psql newdatabase

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/15/16, 5:48 AM
Seen: 387 times
Last updated: 6/21/16, 11:35 PM