Command pg_dump not found

Question

Hello, I have Odoo 8. When I try to backup a database, I get the error "command pg_dump not found". What can I do? I have Windows 7 x64.

Axel Mendoza · Accepted Answer

This always happens due to Odoo can't find where are postgresql_client installed(if it's True that is installed, perhaps you have no instalation of this packages or Odoo have no user rights to access it).
You could config the exact location of your pg_path where the postgresql_client tools are located. This could be done in your config file used to launch Odoo adding
pg_path = /path/to/postgresql/bin

Antoine Huvelle (ahu) · Answer

Also spotted the following solution:
If you've go several OE versions installed on your Windows OS, you may need to change the pg_path variable of the .conf file of your Odoo server.
I saw a case where, with a v11 and v12 install, the v12 had pg_path = None, which made it impossible for Odoo to guess that postgresql's bin location

Solanki Shamji · Answer

Hello,
You can try take backup from here
Log into the database as an administrator through postgre Admin III and backup your database from there.
May be this will help you.
Thanks,
Shamji

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

Aashim Bajracharya · Answer

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

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

Matthew Harrison · Answer

If you are on windows consider adding the  'C:\Program Files\PostgreSQL\10\bin' to your PATH environment variables and restart the odoo server. After that, you should be able to backup from the UI.

関連投稿	返信	ビュー
Error Restoring database 解決済 v8 postgresql backup	1 10月 15	26501
How do you implement the Associations: Members website module? 解決済 v8	3 7月 25	9854
How to Integrate a Full-Screen Color Testing Tool with Odoo Website Builder? v8	1 5月 25	2073
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 解決済 backup	9 7月 25	67332
how to backup ? 解決済 backup	9 7月 24	103688

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！