[13] backup not working - Database backup error: Command `pg_dump` not found.

Question

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

Database backup error: Command `pg_dump` not found.

Chetan · Accepted 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

Sébastien CLAUDE · Answer

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

Atchuthan - Technical Consultant, Sodexis Inc · Answer

I found the answer in issues:  https://github.com/Yenthe666/InstallScript/issues/178 [1]  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."

[1] https://github.com/Yenthe666/InstallScript/issues/178

bisyri mustofa · 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

Waleed Ali Mohsen · 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 [1]

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

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!