Technical mailing list archives

technical@mail.odoo.com

Avatar

Re: Database Restore Error

by
cant
- 14/12/2017 12:48:32
It contains a dump file created with pg_dump

so you can use psql command line tool "psql -q -h ${DATABASE_HOST} -U ${USER_NAME} -d ${DATABASE} -f dump.sql"

2017-12-14 20:45 GMT+03:00 Arlosyst <arlosyst@gmail.com>:
How do we restore ZIP backup via postgres?

On Thu, Dec 14, 2017 at 10:20 PM, Xavier Brochard <zeroheure@gmail.com> wrote:
Le jeudi 14 décembre 2017, 13:00:13 CET Arlosyst a écrit : > Hi All, > I am trying to restore DB of size 1.25 GB to Odoo server. However, I am > getting error "Database restore error: MemoryError()" when i am trying to > do so. Has anyone faced similar issue/ > Thanks & Regards, Arlosyst
If you don't want to patch as suggested by Jérome, you may try to restore the db directly on server. I suggest to use lynx text browser for that. First you should increase nginx limit ; add this in your nginx.conf : # increase size to restoring backups client_max_body_size 1300M; Note also that your backup file contains probably the filestore datas and the postgresql dump. You need only the dump to restore the DB. The filestore datas can be directly copied to the server disk (at the right place!). Hope this help Xavier

_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Best Regards,,
Can Tecim, CTO
Projet Grup

Reference