Technical mailing list archives


Re: Database Restore Error

Xavier Brochard
- 14/12/2017 20:15:20
You can either restore the database through
- zip file loaded with a browser
- postgresql command on the server

I've added a quick how-to on my blog

Le jeudi 14 décembre 2017, 17:45:17 CET Arlosyst a écrit :
> How do we restore ZIP backup via postgres?  On Thu, Dec 14, 2017 at 10:20 
PM, Xavier Brochard < [1] > 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