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.
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
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
|Asked: 6/15/16, 5:48 AM|
|Seen: 387 times|
|Last updated: 6/21/16, 11:35 PM|