Skip to Content
This question has been flagged
5 Respostes
21478 Vistes
Avatar
Humanoide servicios para la pyme, S.L.N.E.

When I try to do a backup fore web/database/Backup

thie error appears

Database backup error: Command `pg_dump` not found.

Avatar
Descartar
Avatar
Chetan
Best Answer

You could config the exact location of your pg_path. This could be done in your config file.

pg_path =C:\Program Files\PostgreSQL\12\bin

this worked for me.

But 

This path may vary in your system

So check the file path in your Program Files >>PostgreSQL  and copy the path of bin folder


Avatar
Descartar
Avatar
Sébastien CLAUDE
Best Answer

Deleting "pg_path =None" work fine for Me in /etc/odoo/odoo.conf

Avatar
Descartar
Avatar
Atchuthan - Technical Consultant, Sodexis Inc
Best Answer

I found the answer in issues: https://github.com/Yenthe666/InstallScript/issues/178 and it worked for me

"I assume the script has copied over the configuration value pg_path = None in your config file. If it is set to None it will give a false positive resuling in this traceback. Can you check the configuration file, remove this option, restart the Odoo instance and try again? That should solve it."

Avatar
Descartar
Avatar
bisyri mustofa
Best Answer

open your odoo.conf and find pg_path inside of it

change your default pg_path for example:

pg_path = C:\Odoo\PostgreSQL\bin

to your current pg_path (in this case the path of your PostgreSQL bin)

for example:

pg_path = C:\Program Files\PostgreSQL\16\bin

save and restart odoo service, after that reload your page.

try to backup once more


Avatar
Descartar
Avatar
Waleed Ali Mohsen
Best Answer

Try to add the bath of PostgreSQL client in Odoo config file as below:

pg_path = /path/to/postgresql/bin  


Please refer to the below thread:

https://www.odoo.com/forum/help-1/question/command-pg-dump-not-found-87849  

Avatar
Descartar