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

CRM
e-Commerce
Knjigovodstvo
Zaloga
PoS
Projekt
MRP

All apps

All Posts People Badges

Ključne besede (View all)

odoo accounting v14 pos v15

About this forum

Pomoč

Exception: Couldn't find pg_dump

database postgresql dump

10 Odgovori

12778 Prikazi

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

Avtor

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

Avtor

My both machine are ubuntu

OpenWorks

Avtor

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?????

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi

Related Posts	Odgovori	Prikazi
Database Migration database postgresql	1 jul. 23	6707
How to save the column of the database when deleting the module? database postgresql	1 mar. 15	6351
When should Database be separated on Separate Server. Solved server database postgresql	1 jul. 25	4476
Incremental backup in 2024 ? (self hosted) database postgresql backup	0 jun. 24	2457
Odoo Internal Server Error database postgresql server500	0 maj 24	1884

This question has been flagged

Enjoying the discussion? Don't just read, join in!