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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
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
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
AanmeldenGerelateerde posts | Antwoorden | Weergaven | Activiteit | |
---|---|---|---|---|
|
1
mei 16
|
8401 | ||
|
0
apr. 24
|
2059 | ||
|
1
mrt. 24
|
7941 | ||
|
3
aug. 24
|
3142 | ||
|
2
mrt. 24
|
1746 |