Error: command 'gcc' failed with exit status when installing psycopg2

Question

I need to install psycopg2 for openerp installation process, but I always faced that error. I've already used pip and easy_install and my gcc is the latest version. I really need your help to solve my problem.

This is my complete error with easy_install:

[root@server01 ~]# easy_install psycopg2    
Searching for psycopg2    
Reading http://pypi.python.org/simple/psycopg2/    
Reading http://initd.org/psycopg/    
Reading http://initd.org/projects/psycopg2    
Best match: psycopg2 2.4.5    
Downloading http://initd.org/psycopg/tarballs/PSYCOPG-2-4/psycopg2-2.4.5.tar.gz    
Processing psycopg2-2.4.5.tar.gz    
Running psycopg2-2.4.5/setup.py -q bdist_egg --dist-dir /tmp/easy_install-anWVvJ/psycopg2-2.4.5/egg-dist-tmp-cZbdtn

no previously-included directories found matching 'doc/src/_build' In file included from psycopg/psycopgmodule.c:27:
./psycopg/psycopg.h:31:22: error: libpq-fe.h: No such file or directory In file included from psycopg/psycopgmodule.c:29:

...

error: Setup script exited with error: command 'gcc' failed with exit status 1

Jon Clements · Accepted Answer · 2012-10-16 10:00:19Z

49

You'll need to install the development package for PostgreSQL, which for instance under Ubuntu is a sudo apt-get install libpq-dev... and for CentOS it's yum install postgresql-devel

answered Oct 16, 2012 at 10:00

Jon Clements

143k34 gold badges254 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hafichuk · Accepted Answer · 2014-03-05 21:30:11Z

34

For the case of CentOS, I had this very same problem, that I solved installing these packages:

sudo yum install postgresql-libs
sudo yum install postgresql-devel
sudo yum install python-devel

only then, I was able to perform successfully:

sudo easy_install psycopg2

edited Mar 5, 2014 at 21:30

hafichuk

10.9k11 gold badges41 silver badges54 bronze badges

answered Jan 8, 2013 at 22:27

Nicolás Ozimica

9,7985 gold badges40 silver badges52 bronze badges

2 Comments

hafichuk Over a year ago

Thanks for not assuming that everyone uses Debian. +1

bazinga Over a year ago

"sudo yum install python-devel" should be changed to "sudo yum install python3-devel" for python3.x

Nicolás Ozimica · Accepted Answer · 2014-03-05 22:15:43Z

14

May Your system is missing the Python headers. To fix this, run:

sudo apt-get install python-dev

or

sudo apt-get install python3-dev

edited Mar 5, 2014 at 22:15

Nicolás Ozimica

9,7985 gold badges40 silver badges52 bronze badges

answered Nov 1, 2012 at 11:10

Heroic

9904 silver badges12 bronze badges

3 Comments

surfi Over a year ago

I searched 30 min. Installed python-psycopg2, postgresql-server-dev-9.1, postgresql-plpython-9.1 and libpq-dev. Still got '"gcc" failed with exit status 1. Now with python-dev it works fine ;-)

hafichuk Over a year ago

unless you're using CentOS

Masih Over a year ago

opensuse users should use: sudo zypper install python3-dev

Prashant Gaur · Accepted Answer · 2017-02-17 10:46:51Z

14

On a fresh ubuntu 14.04.2 LTS on an EC2 instance, I was able to install psycopg2 after instaling the following packages:

sudo apt-get install gcc
sudo apt-get install postgres-xc-server-dev
sudo apt-get install libpq-dev
sudo apt-get install postgresql-client-common
sudo apt-get install postgresql-common

And on a fresh AMI linux (CentOS) instance:

sudo yum install postgresql-devel
sudo yum install gcc*

Hope it helps,

Erez

edited Feb 17, 2017 at 10:46

Prashant Gaur

9,86812 gold badges54 silver badges73 bronze badges

answered Nov 10, 2015 at 9:20

ErezK

5421 gold badge5 silver badges10 bronze badges

Comments

Joe Gasewicz · Accepted Answer · 2025-01-27 11:14:14Z

11

i had this problem but was solved by running:

pip install -Iv psycopg2==2.7.7

There is a problem installing the latest version + python3.7

For newer versions of Python use:

pip install psycopg2-binary

edited Jan 27 at 11:14

answered Apr 19, 2019 at 15:14

Joe Gasewicz

1,55518 silver badges24 bronze badges

Comments

Aaron Torgerson · Accepted Answer · 2016-03-01 00:11:01Z

I've been trying to install pgsql on a plain Amazon Linux EC2 instance, and have been getting this error. Per Nicolás answer, I installed his suggested list of packages, but I continued to get the error. Looking more closely at the error, I noticed that the gcc command was including pgsql93 files:

gcc -pthread -fno-strict-aliasing -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.6.1 (dt dec pq3 ext lo64)" -DPG_VERSION_HEX=0x09030A -DHAVE_LO64=1 -I/usr/include/python2.7 -I. -I/usr/include/pgsql93 -I/usr/include/pgsql93/server -c psycopg/psycopgmodule.c -o build/temp.linux-x86_64-2.7/psycopg/psycopgmodule.o -Wdeclaration-after-statement

Looking in /usr/include/ I see pgsql92/ but not pgsql93/. So I took a look at what pgsql-related yum packages were installed and I noticed these:

postgresql92.x86_64 postgresql92-devel.x86_64 postgresql92-libs.x86_64 postgresql93.x86_64 postgresql93-libs.x86_64

Seemed to me like there ought to be a postgresql93-devel, so I tried:

sudo yum install postgresql93-devel

And that fixed the problem for me! So I guess the theme is: Look at the gcc call, and see what dir it's pulling in. Follow the crumbs from there.

neciu · Accepted Answer · 2015-04-08 21:18:06Z

5

For Ubuntu 14.04, from Docker image python:3.4.3-slim this combination worked for me:

sudo apt-get update
sudo apt-get install -y build-essential
sudo apt-get install -y python3.4-dev
sudo apt-get install -y libpq-dev

pip3 install psycopg2

Note build-essential package. It was crucial in my case.

answered Apr 8, 2015 at 21:18

neciu

4,4952 gold badges27 silver badges33 bronze badges

2 Comments

Simon Over a year ago

Man I tried everything before this finally fixed it. Also running a docker image, so pretty much just copied your code into my dockerfile and it worked like a charm

jspinella Over a year ago

On Ubuntu 24.04 all I needed was sudo apt-get install -y libpq-dev

ji-ruh · Accepted Answer · 2017-03-06 08:11:55Z

3

In centos 7. i'd use sudo yum install postgresql96-devel.x86_64 to solved my problem.

answered Mar 6, 2017 at 8:11

ji-ruh

7011 gold badge7 silver badges24 bronze badges

Comments

Daniel Fischer · Accepted Answer · 2012-10-16 09:43:59Z

2

The invocation of gcc failed, gcc couldn't compile the source. Probably the cause is

./psycopg/psycopg.h:31:22: error: libpq-fe.h: No such file or directory In file included from psycopg/psycopgmodule.c:29:

that the header libpq-fe.h is nowhere in the search path if you have it at all.

answered Oct 16, 2012 at 9:43

Daniel Fischer

184k19 gold badges319 silver badges436 bronze badges

2 Comments

ws_123 Over a year ago

what should i do with libpq-fe.h? could you give me more explanation?

Daniel Fischer Over a year ago

Check if you have it at all. If not, install the package that provides it, libpq-devel or libpq-dev or something similar, depending on distribution.

schnbrg · Accepted Answer · 2015-01-22 23:04:07Z

2

This worked for me on Ubuntu Server 14.10 64-bit:

sudo apt-get install libpqxx-dev

answered Jan 22, 2015 at 23:04

schnbrg

212 bronze badges

Comments

Jeff · Accepted Answer · 2014-07-18 16:13:08Z

1

For me, the missing package was

libpqxx-devel.x86_64

answered Jul 18, 2014 at 16:13

Jeff

4,47316 gold badges68 silver badges120 bronze badges

Comments

Dksingh · Accepted Answer · 2020-01-10 12:07:12Z

1

psycopg2 is also available on PyPI in the form of wheel packages for the most common platform (Linux, OSX, Windows): this should make you able to install a binary version of the module, not requiring the above build or runtime prerequisites.

You can use this command : pip install psycopg2-binary

Note The psycopg2-binary package is meant for beginners to start playing with Python and PostgreSQL without the need to meet the build requirements. If you are the maintainer of a publish package depending on psycopg2 you shouldn’t use ‘psycopg2-binary’ as a module dependency. For production use you are advised to use the source distribution.

answered Jan 10, 2020 at 12:07

Dksingh

591 silver badge11 bronze badges

1 Comment

eis Over a year ago

so... why am I getting " unable to execute 'gcc': No such file or directory" when running that command? why does it need gcc if I'm trying to install the binary version of the module?

Edward Spencer · Accepted Answer · 2021-09-21 10:49:45Z

0

I was running 3.9-alpine for CICD and had to install these packages to get it working;

apk add postgresql-dev
apk add gcc
apk add musl-dev

Then I was able to run a pip install psycopg2 as normal.

answered Sep 21, 2021 at 10:49

Edward Spencer

7681 gold badge11 silver badges15 bronze badges

Collectives™ on Stack Overflow

Error: command 'gcc' failed with exit status when installing psycopg2

13 Answers 13

Comments

2 Comments

3 Comments

Comments

Comments

Comments

2 Comments

Comments

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

Comments

2 Comments

3 Comments

Comments

Comments

Comments

2 Comments

Comments

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related