Mac + virtualenv + pip + postgresql = Error: pg_config executable not found

by

On the Mac, if you’re using Postgres.app, the pg_config file is in your /Applications/Postgres.app/Contents/Versions/<current_version>/bin directory. That’ll need to be added to your system path to fix this error, like this:

export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/<current_version>/bin

So for example, if the current Postgres.app version is 9.5, this export line would be:

export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.5/bin

With more recent versions of the Postgres.app (> 9.5?), you can simply add “latest” in place of the version number, like so:

export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/latest/bin

More Related Contents:

  1. Psycopg2 image not found
  2. Error Installing Psycopg2 on MacOS 10.9.5
  3. psycopg2: insert multiple rows with one query
  4. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  5. Passing table name as a parameter in psycopg2
  6. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  7. error installing psycopg2, library not found for -lssl
  8. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  9. How to set up a PostgreSQL database in Django
  10. Can’t install psycopg2 package through pip install on MacOS
  11. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  12. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  13. Create a Postgres database using python
  14. How to find pg_config path
  15. Python/postgres/psycopg2: getting ID of row just inserted
  16. Escape SQL “LIKE” value for Postgres with psycopg2
  17. How to set connection timeout in SQLAlchemy
  18. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  19. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  20. Insert Python Dictionary using Psycopg2
  21. Use binary COPY table FROM with psycopg2
  22. How Postgresql COPY TO STDIN With CSV do on conflic do update?
  23. How to uninstall Python 2.7 on a Mac OS X 10.6.4?
  24. “OSError: [Errno 1] Operation not permitted” when installing Scrapy in OSX 10.11 (El Capitan) (System Integrity Protection)
  25. Finding the Current Active Window in Mac OS X using Python
  26. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  27. pip installation /usr/local/opt/python/bin/python2.7: bad interpreter: No such file or directory
  28. psycopg2 TypeError: not all arguments converted during string formatting
  29. Installing Pygame for Mac OS X 10.6.8
  30. easy_install with various versions of python installed, mac osx

Leave a Comment