Exception: Couldn't find pg_dump

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Project
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Exception: Couldn't find pg_dump

database postgresql dump

10 Vastaukset

11978 Näkymät

OpenWorks

I am getting while getting backup of odoo database from database manager.

My postgres server is on another server, I have configured pg_path accordingly.

while taking backup it is giving me error like

Traceback (most recent call last):
  File "/home/software/ws/odoo/openerp/http.py", line 108, in dispatch_rpc
    result = dispatch(method, params)
  File "/home/software/ws/odoo/openerp/service/db.py", line 70, in dispatch
    return fn(*params)
  File "/home/software/ws/odoo/openerp/service/db.py", line 176, in exp_dump
    dump_db(db_name, t)
  File "/home/software/ws/odoo/openerp/service/db.py", line 169, in wrapper
    return func(*args, **kwargs)
  File "/home/software/ws/odoo/openerp/service/db.py", line 200, in dump_db
    if openerp.tools.exec_pg_command(*cmd):
  File "/home/software/ws/odoo/openerp/tools/misc.py", line 90, in exec_pg_command
    raise Exception('Couldn\'t find %s' % name)
Exception: Couldn't find pg_dump

Paulo Matos‏

I am having the same problem whille backing up a database. The database is not at the same server as Odoo and already tried to add the pg_path to configuration file with no luck. So, do I need to have postgresql also installed on odoo server host?

Apoorv Soral

I am using aws RDS for DB server and EC2 for appserver. I am also getting the same error. Is there any option to fix the issue.Could you please also tell me how did you guys setup the pg_path?????

Rihene

As i know mmmm ...pg_dump is a utility for backing up Postgres DB, the worse I'm afraid you'll have to make up with postgres ... here is a useful link:

http://www.thegeekstuff.com/2009/01/how-to-backup-and-restore-postgres-database-using-pg_dump-and-psql/

OpenWorks

Tekijä

Thanks for the answer, I have already configure pg path to /usr/lib/postgresql/9.1/bin/. but it is still not working

Rihene

which OS are you working with?

OpenWorks

Tekijä

My both machine are ubuntu

OpenWorks

Tekijä

pg_path is /usr/lib/postgresql/9.1/bin/

Rihene

Your pg_path must be under /etc ( Specify the PostgreSQL executable path.)

Paulo Matos‏

Hi there,

Confirmed that just installing postgresql on Odoo server machine, this problem is fixed.

I have installed postgresql on odoo server and made no changes on it. Just installed it in order to allow odoo to find the "pg_dump" application and leave "pg_path = None" on the odoo configuration file.

Perhaps there is another solution for solving this problem, but it's working this way.

Regards

Apoorv Soral

I am using aws RDS for DB server and EC2 for appserver. I am also getting the same error. Is there any option to fix the issue.Could you please also tell me how did you guys setup the pg_path?????

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Database Migration database postgresql	1 heinäk. 23	5992
How to save the column of the database when deleting the module? database postgresql	1 maalisk. 15	5433
When should Database be separated on Separate Server. Ratkaistu server database postgresql	1 heinäk. 25	3581
Incremental backup in 2024 ? (self hosted) database postgresql backup	0 kesäk. 24	1726
Odoo Internal Server Error database postgresql server500	0 toukok. 24	1300

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!