Restore Database From Command Line Using Dump File in Odoo

[@Dil-ka-music]

Hi sir, I am using odoo 11 and i get internal server error or server overloaded error on clicking on backup database option in database manager. Around 2 years of my company data is stuck since 1.5 years. It used to work well previously. I don't know what happened. I also tried taking backup from pgadmin 3 application from postgresql software. But the file formats or different than the ones from direct backup from odoo application. And it doesn't work. Moreover it shows several options while backup which i dont understand. Plz help

[@OdooMates]

Can you try by increasing memory limits in the configuration file and see

[@Dil-ka-music]

@@OdooMates Hello sir, after you have told me about the memory limits, i tried creating a sample new test database and tried backing it up to see if at all the size of the database is what holding it back. but interestingly, Now i am receiving a different error. Commmand 'pg_dump' not found. It is Probably because i have upgraded the older odoo 9.0 to odoo 11.0 and so the data is stored somewhere in odoo 9.0 folder in C and the odoo is operating from a different folder odoo 11.0. I don't knw. its just a thought. the errors started to happen probably since the upgrade.... Now i am realizing.

[@OdooMates]

There will be a file ending with .conf most probably it will be odoo.conf, it will be in side the etc folder

[@Dil-ka-music]

@@OdooMates I already found the file and opened it in notepad sir. Found directly in server folder in odoo 11.0 But the limit_memory_hard and limit_memory_soft lines are set to none which i guess should not be a problem. I researched online and found that a pg_dump path is missing in the config file and therefore it is giving such command pg_dump missing error. I couldn't solve that by adding lines to the file...!! Any help there?

[@youtubeoneverything4581]

thnak you. this is useful for large filestore DBs like >10gb

[@OdooMates]

Glad it helped

[@youtubeoneverything4581]

@@OdooMates your videos are short and to the point. I like that very much

[@OdooMates]

Thanks very much for the support ❤️❤️❤️

[@EvansAdji]

Hai.. thanks alot... very useful.. right on target.. btw is there a restore tutorial with docker? greatly appreciated

[@OdooMates]

Not yet made any video docket yet

[@aashimbajracharya]

@@OdooMates Hoping to this one via docker soon.

[@ymsoft2863]

@@aashimbajracharya hola amigo para restaurar con docker si tienes el problema que se corta la restauracion utiliza tu ip:8069 y desde ese link restauras la base de datos

[@mohamdalhelal6249]

thanks, thats was very good explanation

[@OdooMates]

Glad it was helpful!

[@solomonkamariki6342]

Can you make a demo for odoo14 & odoo17 docker?

[@vigneshmurugesh1940]

Hi sir, how to do it in Windows 10?.

[@OdooMates]

using the command prompt in windows, you can try below steps,

[@70abod]

thanks, thats was very helpful

[@OdooMates]

glad it helped

[@abdullahmeaad1362]

thank you for the video , after finishing the restoring i got an error when updating any module , -> psycopg2.ProgrammingError: must be owner of relation

[@OdooMates]

Seems you have to change the owner of db to odoo running postgres user

[@usmanfarzand4078]

Great and thanks Niyyas

[@iyadsaleh3695]

thanks

[@OdooMates]

welcome

[@vanetti8771]

good

[@OdooMates]

Thanks