Thursday, 4 July 2013

Django - Install Psycopg2 on Mac OS X - pg_config path issue AND lipo: can't open input file - Issues Resolved

In one of my recent Django based projects, I happened to use PostgreSQL as Database Backend. In order to connect the db and for other operations with PostgreSQL, python's psycopg2 module is pretty popular and readily used. Psycopg2 got easily installed on the Linux (Ubuntu) machine but I faced some issues when I tried to install it on my Mac OS X 10.6.7. After following several tips and reading several blog posts, I finally managed to find the actual working solution which resolved the issues of installing Psycopg2 on Mac OS X. I also noticed that many people were trying to find solution of the same issues which I faced. So I am writing their solutions in a single blog post in a descriptive and step-by-step manner. There are basically two most common issues which I also faced while installing psycopg2 on Mac OS X:


When I tried to install psycopg2 on Mac OS X and entered following command on my terminal:

>pip install psycopg2

I got an error that pg_config file's path is not specified. Following is the full trace:

Error: pg_config executable not found.

Please add the directory containing pg_config to the PATH

or specify the full executable path with the option:

    python build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

Command python egg_info failed with error code 1 in /tmp/pip-build/psycopg2


Provided that some version of PostgreSQL is already installed, you will have to explicitly add the PATH of pg_config file in your PostgreSQL bin folder. In my case, the installation PATH for PostgreSQL is:


so to define the PATH of pg_config file, I entered following command in my terminal:
> PATH=$PATH:/opt/local/lib/postgresql91/bin/

After running this command, the pg_config path error while installing psycopg2 was resolved


While installing psycopg2 on my Mac OS X, the pip install psycopg2 command returned following error:

lipo: can't open input file: /var/tmp//ccTy5xAu.out (No such file or directory)

Full trace of the error is as follows:

psycopg/psycopgmodule.c:951: fatal error: error writing to -: Broken pipe

compilation terminated.

lipo: can't open input file: /var/tmp//ccTy5xAu.out (No such file or directory)

error: command 'gcc-4.2' failed with exit status 1


After a googling a bit, and trying several recipes, the solution that worked for me was the following command which overrides the ARCHFLAGS architecture settings:

sudo env ARCHFLAGS="-arch i386 -arch x86_64" pip install psycopg2

This command finally installed psycopg2 on my Mac OS X without any issues.


  1. Not so far I have found new cool tool to work on mac os x - Valentina Studio. Its free edition can do things more than many commercial tools!!
    I very recommend check it.
    You can install Valentina Studio (FREE) directly from Mac App Store:

    1. thân thể của lão tổ.

      Nhạc Thành chăm chú nhìn thấy tất cả, Long Khiếu Phượng Vũ này tựa hồ như không phải là đấu kỹ của Nhạc gia, không biết Nhạc Thiên lão tổ học được ở đâu.

      Long Khiếu Phượng Vũ này cơ hồ còn mạnh hơn cả so với Long Khiếu Cửu Thiên.

      Đám mây đen vốn đang tràn ngập thì có một con hoàng kim cự long và một con phượng hoàng bảy sắc xuất hiện, mây đen xung quanh bỗng nhiên biến mất, chỉ còn lại bảy sắc cầu vồng đẹp tươi.
      game mu
      cho thue phong tro
      nhac san cuc manh
      tổng đài tư vấn luật
      văn phòng luật
      tổng đài tư vấn pháp luật
      thành lập công ty
      chém gió
      trung tâm ngoại ngữ
      Dưới sắc màu tươi đẹp này không gian bỗng nhiên sáng ngời lên.

      Điều khiến cho mọi người rung động chính là kim long hư ảnh cùng với phượng hoàng bảy sắc có một cái khe không gian bị xé rách, khí tức gào thét.

      - Ngao.

      Từng thanh âm vang lên, con phượng hoàng bay lên trên không trung, điên cuồng đánh về phía

  2. Thanks Ali, this post helped. I ran into an additional clang issue on Mavericks:

    clang: error: unknown argument: '-mno-fused-madd' [-Wunused-command-line-argument-hard-error-in-future]
    clang: note: this will be a hard error (cannot be downgraded to a warning) in the future
    error: command 'cc' failed with exit status 1

    I had to modify the install command as follows to ignore the clang warning:

    sudo env ARCHFLAGS="-arch i386 -arch x86_64 -Wno-error=unused-command-line-argument-hard-error-in-future" pip install psycopg2

  3. Thanks,

    I tried but I also had to add the environment variable:

    export DYLD_LIBRARY_PATH=/Library/PostgreSQL/9.3/lib

  4. Thank you!! Solution 1 was I what I needed.

  5. Thanks. I have wasted ages on this today and this is the first post I have come across that fixes my issue

  6. Before you hire someone for your app development project, it will be good that you chalk out a set of questions for the developer. Edknt Media

  7. Coming up with great Instagram captions every day can be hard. We make that job easy for you with the best instagram captions for couples apps for both Android and iOS.

  8. Flutter Programming is one of the most popular in the cross platforms industry. We build excellent Flutter Development Company and also learn how to overcome performance issues. is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.

  9. As web app development company it is important for us to find new websites and understand about it from design to development.
    web design company in toronto

  10. But, Python on the other hand was specifically developed keeping in mind newcomers. Even to the eye of a layman, it will seem meaningful and easy to understand. unindent does not match any outer indentation level python

  11. Looking for the best SEO companies in Toronto? 1Solutions is the best SEO Company in Toronto with the best client reviews and ratings. Hence, Hiring SEO Experts in Toronto or outsourcing talent from a top-rated SEO Agency in Toronto can come in handy. 1Solutions has served many industries like eCommerce, Law, Education, Information Technology with the rankings of hundreds of keywords on the first page in Search Engines.

  12. Hi there, yes this post is genuinely nice and I have learned lot,of things from it on the topic of blogging.

    횟수 무제한 출장

  13. If you are planning to study or work abroad then you have to take the IELTS test to prove your English language efficiency. Then you have to join the best IELTS Coaching in Delhi for the preparation IELTS test. We aim to develop the student completely. Hence, Multilingua gives training for all the four sections of IELTS, that is, reading, writing, listening, and speaking. All the courses and training are majorly crafted to make you shine in your exam. Mastering all four sections will help you gain a good pointers.

  14. It's amazing. I want to learn your writing skills. In fact, I also have a website. If you are okay, please visit once and leave your opinion. Thank you. 바카라게임사이트