Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Exception: Couldn't find pg_dump

Subscribe

Get notified when there's activity on this post

This question has been flagged
databasepostgresqldump
10 Replies
12724 Views
Avatar
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

0
Avatar
Discard
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?

Avatar
Apoorv Soral
Best Answer

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

0
Avatar
Discard
Avatar
Rihene
Best Answer

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/

0
Avatar
Discard
OpenWorks
Author

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
Author

My both machine are ubuntu

OpenWorks
Author

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

Rihene

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

Avatar
Paulo Matos‏
Best Answer

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


0
Avatar
Discard
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!

Sign up
Related Posts Replies Views Activity
Database Migration
database postgresql
Avatar
Avatar
1
Jul 23
6623
How to save the column of the database when deleting the module?
database postgresql
Avatar
Avatar
1
Mar 15
6260
When should Database be separated on Separate Server. Solved
server database postgresql
Avatar
Avatar
1
Jul 25
4390
Incremental backup in 2024 ? (self hosted)
database postgresql backup
Avatar
0
Jun 24
2400
Odoo Internal Server Error
database postgresql server500
Avatar
0
May 24
1831
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now