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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Project
- MRP
Diese Frage wurde gekennzeichnet
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 )
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
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
1
Mai 16
|
8378 | ||
|
0
Apr. 24
|
2053 | ||
|
1
März 24
|
7923 | ||
|
3
Aug. 24
|
3139 | ||
|
2
März 24
|
1743 |