How to install psycopg2 with "pip" on Python?

Question

I'm using virtualenv and I need to install "psycopg2".

I have done the following:

pip install http://pypi.python.org/packages/source/p/psycopg2/psycopg2-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160

And I have the following messages:

Downloading/unpacking http://pypi.python.org/packages/source/p/psycopg2/psycopg2
-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160
  Downloading psycopg2-2.4.tar.gz (607Kb): 607Kb downloaded
  Running setup.py egg_info for package from http://pypi.python.org/packages/sou
rce/p/psycopg2/psycopg2-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160
    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 setup.py build_ext --pg-config /path/to/pg_config build ...

    or with the pg_config option in 'setup.cfg'.
    Complete output from command python setup.py egg_info:
    running egg_info

creating pip-egg-info\psycopg2.egg-info

writing pip-egg-info\psycopg2.egg-info\PKG-INFO

writing top-level names to pip-egg-info\psycopg2.egg-info\top_level.txt

writing dependency_links to pip-egg-info\psycopg2.egg-info\dependency_links.txt

writing manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'

warning: manifest_maker: standard file '-c' not found

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 setup.py build_ext --pg-config /path/to/pg_config build ...



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

----------------------------------------
Command python setup.py egg_info failed with error code 1
Storing complete log in C:\Documents and Settings\anlopes\Application Data\pip\p
ip.log

My question, I only need to do this to get the psycopg2 working?

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

Did it work when you tried python setup.py build_ext --pg-config /path/to/pg_config build ... ?? — lajarre, Oct 12 '12 at 09:25
For python 3.4 or python 3.5, you have to install the corresponding verion's dev package like `sudo apt install libpq-dev python3.4-dev` or `sudo apt install libpq-dev python3.5-dev` — Avinash Raj, Jan 01 '17 at 03:15

joar · Accepted Answer · 2021-05-19T12:23:24.840

927

Note: Since a while back, there are binary wheels for Windows in PyPI, so this should no longer be an issue for Windows users. Below are solutions for Linux, Mac users, since lots of them find this post through web searches.

Option 1

Install the psycopg2-binary PyPI package instead, it has Python wheels for Linux and Mac OS.

pip install psycopg2-binary

Option 2

Install the prerequsisites for building the psycopg2 package from source:

Debian/Ubuntu

Python 3

sudo apt install libpq-dev python3-dev

You might need to install python3.8-dev or similar for e.g. Python 3.8.

Python 2¹

sudo apt install libpq-dev python-dev

If that's not enough, try

sudo apt install build-essential

or

sudo apt install postgresql-server-dev-all

as well before installing psycopg2 again.

CentOS 6

See Banjer's answer

¹ Really? It's 2021

edited May 19 '21 at 12:23

answered Mar 27 '11 at 15:25

joar

11,869
1
26
51

7

11.04: different errors, the same solution. Worship to dev versions! – I159 Dec 17 '11 at 17:09
5

@I159 - The `*-dev` packages contain the files necessary to compile an application *from source* that uses the functions provided by the library (as `psycopg2` uses the `libpq` and `python` libraries, among others). – joar Dec 19 '11 at 09:17
2

Works on Ubuntu 11.10 as well. Thanks! – xamox Apr 22 '12 at 20:25
21

I'm using Ubuntu 12.04 LTS, and I also had to `sudo apt-get install postgresql-server-dev-all` – caleb Jun 06 '12 at 19:38
how can i install libpq-dev python-dev packages in opensuse? – Pravitha V Jul 05 '12 at 11:22
5

Could someone please explain why not just the directory containing pg_config to the PATH (or use --pg-config)? – lajarre Oct 11 '12 at 11:56
Works for me on Ubuntu 12.10. – Seth Nov 10 '12 at 22:00
1

I found I only needed to install `libpq-dev`, which is fortunate, as `python-dev` wouldn't install. – Duncan Parkes Dec 18 '12 at 11:15
1

I'm missing something. I'm using virtualenv as a convenience to perform local installs because I don't have root privileges on my deployment server. Does anyone know the actual answer to the original question, because I do know that my machine and the deployment server do have the needed dependencies, I just won't have permission to re-deploy. – David Berger Aug 08 '13 at 20:39
@DavidBerger if you have the libpq-dev and python-dev packages installed, your virtualenv's pip should install it just fine. – joar Aug 08 '13 at 21:09
@joar Not entirely true. At least, I have the python modules I need in my site-packages, although I'm unsure how they got there. But pip crashes with the above error. Of course, my destination environment also has the necessary dependencies, so virtualenv --system-site-packages allows me to do what I need without pip install, but I didn't originally want to go that route. – David Berger Aug 09 '13 at 21:04
As a note: this is an *excellent* example of why post-only answers should not be allowed. The link no longer works. – Gordon Linoff May 31 '15 at 15:06
6

If you are here because you are having trouble installing psycopg2 into the python 3 Celery container from Dockerhub you will also need to install build-essential with `sudo apt-get install -y build-essential` – derrend Sep 20 '15 at 10:38
I had to do sudo apt-get install libpq-dev python3-dev as im using python3 – Storm Oct 06 '16 at 11:52
On ubuntu 14.04.5 and python3 what worked for me was: sudo apt install libpq-dev python3-dev – JesusAlvSoto Oct 16 '16 at 12:45
1

@Tessaracter It's accepted because it's the correct answer. You can't install `libpq-dev` and `python-dev` with pip, you need to install both `libpq-dev` and `python-dev` before you run `pip install psycopg2`. – joar Sep 10 '19 at 15:10
1

This is not working for python 3.8, python 3.7 worked well. – Fawwaz Yusran Jan 21 '20 at 07:42
@FawwazYusran You might have to install python3.8-dev or a similarly named package. – joar Feb 06 '20 at 19:36
Works on ubuntu 20.04. Thank you! – Sarthak May 06 '20 at 12:04

score 119 · Answer 2 · edited Jun 23 '14 at 09:21

119

On CentOS, you need the postgres dev packages:

sudo yum install python-devel postgresql-devel

That was the solution on CentOS 6 at least.

edited Jun 23 '14 at 09:21

Andomar

216,619
41
352
379

answered Oct 31 '12 at 13:03

Banjer

7,457
4
42
61

1

This isn't just CentOS, I think. psycopg has native dependencies, so to build from source (which is what pip does), the PostgreSQL development libraries need to be there. (The C headers, maybe? I don't know much about compiling native code.) – jpmc26 Jun 01 '13 at 20:37
4

I concur that this solves the problem on CentOS 6. I would like to add that I did have to add /usr/pgsql-9.3/bin to $PATH. Here is a post giving an example of how to do that. http://serverfault.com/questions/102932/adding-a-directory-to-path-in-centos – Ryder Brooks Feb 28 '14 at 00:41
For CentOS 7 and Python 3.4 I had to install "python34-devel". My answer to a related question: http://stackoverflow.com/a/42370489/26219 – Mark Edington Feb 21 '17 at 14:52
Worked on AWS EC2, with RHEL-based 64bit Amazon Linux/2.5.1 – Ben Wheeler Sep 08 '17 at 19:33
For Python3 in Fedora use `sudo yum install python36-devel` (replace 36 with your version of Python 3). – LoMaPh Apr 06 '19 at 00:35

score 89 · Answer 3 · answered Dec 22 '13 at 01:51

89

On Mac Mavericks with Postgres.app version 9.3.2.0 RC2 I needed to use the following code after installing Postgres:

sudo PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.3/bin pip install psycopg2

answered Dec 22 '13 at 01:51

metasequoia

6,096
5
37
54

sudo PATH=$PATH:/Applications/Postgres93.app/Contents/MacOS/bin pip install psycopg2 [as of April 5, 2014] – user798719 Apr 05 '14 at 18:42
Confirmed for Postgres.app 9.3.5 also :) – oden Aug 15 '14 at 11:38
With Postgres.app 9.3.5 Mac OS X Version 10.9.4, I had to add `export PATH=${PATH}:/Applications/Postgres.app/Contents/Versions/9.3/bin/` to the `~/.bash_profile` and open a new window before psycopg2 installed. The path specified by @user798719 doesn't exist for me and I just installed Postgres.app on my computer today [September 11,2014]. – Richard D Sep 11 '14 at 06:38
2

if you are using virtualenv you dont need 'sudo' so active your virtualenv and run 'PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.3/bin pip install psycopg2' – elin3t Sep 15 '14 at 19:00
3

My case OS X Ver 10.9.4: sudo PATH=$PATH:/Library/PostgreSQL/9.2/bin pip install psycopg2 – emecas Sep 28 '14 at 11:36
3

Yes, this worked for me too. After installing PostgreSQL, I had to set my path by doing `PATH=$PATH:/Library/PostgreSQL/9.4/bin pip install psycopg2`. – iamfrancisyo Jan 26 '15 at 07:47
5

Use the latest version: PATH=$PATH:/Applications/Postgres.app/Contents/Versions/latest/bin pip install psycopg2 – Diego Sarmiento Sep 07 '16 at 21:01
Saved me ,For My Mac 10.13.3 ,python -v :2.7.10 pip -version :10.0.0 .The pip install psycopg2 was not working – sg28 Apr 16 '18 at 09:14

score 82 · Answer 4 · answered Oct 31 '13 at 16:26

82

if you're on a mac you can use homebrew

brew install postgresql

And all other options are here: http://www.postgresql.org/download/macosx/

Good luck

answered Oct 31 '13 at 16:26

nichochar

2,062
14
13

2

nichochar's answer and attomos's answer (install postgresql and modify path) together resolved the issue for me. the easiest way to edit the path is to run "sudo nano /etc/path" from your terminal. – tbradley22 Jul 13 '14 at 05:38
2

Thank you for this. I was about to go insane before I found this! – Leo C Han Oct 29 '14 at 17:37
1

Worked for me too, no need to monkey with my path (and generally, I wouldn’t recommend sudo here - you should be able to do this in user space). – duozmo Jul 01 '15 at 23:03
This does not install the postgresql in the `virtualenv` like the OP asked. – Jorge Leitao Feb 17 '17 at 14:38
I don't think OP necessarily wanted postgres in the virtualenv. He said he is using virtualenv. I think he misunderstood that postgresql is a bigger service than simply a python library. – nichochar Feb 18 '17 at 16:26
Works! Thanks a lot, I spent too much time on this. – Palak Bansal Jun 06 '19 at 11:44
Best answer for Mac OS user – Axis Jul 04 '19 at 00:49
Best and simple answer! – Mustafa Oct 19 '19 at 17:23

score 62 · Answer 5 · edited Jun 01 '13 at 20:52

62

I recently configured psycopg2 on a windows machine. The easiest install is using a windows executable binary. You can find it at http://stickpeople.com/projects/python/win-psycopg/.

To install the native binary in a virtual envrionment, use easy_install:

C:\virtualenv\Scripts\> activate.bat
(virtualenv) C:\virtualenv\Scripts\> easy_install psycopg2-2.5.win32-py2.7-pg9.2.4-release.exe

edited Jun 01 '13 at 20:52

jpmc26

23,237
9
76
129

answered Mar 24 '11 at 15:01

Praveen Gollakota

30,900
7
57
60

3

Thanks for the reply. But I need to install to an virtual environment. Best Regard, – André Mar 24 '11 at 15:07
4

This [trick](http://nedbatchelder.com/blog/201007/installing_python_packages_from_windows_installers_into.html) (courtesy, Ned Batchelder) has helped me in the past to install from binaries to a virtualenv – Praveen Gollakota Mar 24 '11 at 16:07
14

Is there really no way to get "pip install psycopg2" working on Windows? Even if a patch to psycopg2 is necessary, it would be worth it. – slacy Jun 03 '11 at 17:09
1

I got this error when postgres was not installed on my machine - I installed postgres and the error went away ... – Sam Joseph Mar 14 '12 at 12:42
This was a lifesaver. Thanks a lot! – Unknown Coder Feb 19 '14 at 21:08
2

the stickpeople link also discusses virtual env and points to a pip install version https://github.com/nwcell/psycopg2-windows – seanv507 Jan 06 '15 at 11:24
I'm using a windows and inside a virtualenv and the easy_install psycopg2 worked like a charm. – Dave Mar 01 '15 at 22:40
Thanks, easy_install worked. Only problem was that it added to "venv\Lib\site-packages\psycopg2-2.6.1-py3.4-win32.egg\" directory this psycopg2 module/directory. All i had to do was copy it to site-packages folder – qwerty Jun 29 '15 at 20:45
Only @seanv507 comment solved my problem, however that linked repo is abandoned. Checkout [this link](https://github.com/zeluspudding/psycopg2-windows/blob/master/README.md) for an updated solution (psycopg2.6.2 + Win64 + env) – zelusp Sep 29 '16 at 03:09

score 28 · Answer 6 · answered Oct 03 '12 at 18:39

28

For Python 3 you should use sudo apt-get install libpq-dev python3-dev under Debian.

answered Oct 03 '12 at 18:39

André

1,732
1
21
24

radtek · Answer 7 · 2017-02-22T23:29:58.487

27

This is what worked for me (On RHEL, CentOS:

sudo yum install postgresql postgresql-devel python-devel

And now include the path to your postgresql binary dir with you pip install:

sudo PATH=$PATH:/usr/pgsql-9.3/bin/ pip install psycopg2

Make sure to include the correct path. Thats all :)

UPDATE: For python 3, please install python3-devel instead of python-devel

edited Feb 22 '17 at 23:29

answered Nov 20 '14 at 15:14

radtek

26,590
9
126
97

Note that I didn't need to update the PATH environment variable. – grim Aug 25 '15 at 04:03
1

You shouldn't have to if you reload your terminal session. – radtek Aug 27 '15 at 18:54
Excelent Thank you so much . – Jorge Vidinha Jan 14 '17 at 08:42
If you are using Python 3 you'll need to install numbered Python devel packages. See: http://stackoverflow.com/a/42370489/26219 – Mark Edington Feb 21 '17 at 14:55

score 21 · Answer 8 · answered Apr 02 '12 at 07:22

21

If you using Mac OS, you should install PostgreSQL from source. After installation is finished, you need to add this path using:

export PATH=/local/pgsql/bin:$PATH

or you can append the path like this:

export PATH=.../:usr/local/pgsql/bin

in your .profile file or .zshrc file.

This maybe vary by operating system.

You can follow the installation process from http://www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source/

answered Apr 02 '12 at 07:22

attomos

942
3
14
28

1

Why from source instead of Homebrew? – duozmo Jul 01 '15 at 22:48
@duozmo it was answered in 2012 and I believe I did try to install it with Homebrew at that time but it failed. Now, I've installed PostgreSQL using Homebrew without any problems. – attomos Jul 02 '15 at 05:20

score 18 · Answer 9 · answered Jan 17 '15 at 19:41

The answers so far are too much like magic recipes. The error that you received tells you that pip cannot find a needed part of the PostgreSQL Query library. Possibly this is because you have it installed in a non-standard place for your OS which is why the message suggests using the --pg-config option.

But a more common reason is that you don't have libpq installed at all. This commonly happens on machines where you do NOT have PostgreSQL server installed because you only want to run client apps, not the server itself. Each OS/distro is different, for instance on Debian/Ubuntu you need to install libpq-dev. This allows you to compile and link code against the PostgreSQL Query library.

Most of the answers also suggest installing a Python dev library. Be careful. If you are only using the default Python installed by your distro, that will work, but if you have a newer version, it could cause problems. If you have built Python on this machine then you already have the dev libraries needed for compiling C/C++ libraries to interface with Python. As long as you are using the correct pip version, the one installed in the same bin folder as the python binary, then you are all set. No need to install the old version.

And about Os x? I mean, is based on Unix but I think can be different. — Lara, Feb 10 '15 at 20:25

score 13 · Answer 10 · answered Sep 06 '15 at 14:27

13

On Debian/Ubuntu:

First install and build dependencies of psycopg2 package:

# apt-get build-dep python-psycopg2

Then in your virtual environment, compile and install psycopg2 module:

(env)$ pip install psycopg2

answered Sep 06 '15 at 14:27

Omid Raha

7,550
1
43
55

score 6 · Answer 11 · answered Feb 27 '12 at 03:35

6

I've done this before where in windows you install first into your base python installation.

Then, you manually copy the installed psycopg2 to the virtualenv install.

It's not pretty, but it works.

answered Feb 27 '12 at 03:35

monkut

36,357
21
109
140

2

can you elaborate please. Where do you get the psycopg2 at the first place? – Saher Ahwal Jun 14 '12 at 05:04
2

windows binaries are available at http://stickpeople.com/projects/python/win-psycopg/ – monkut Jun 14 '12 at 06:03
I did this as well, after exhausting days and all other options that have been described online. I'm still dumbfounded as to what was preventing it from being installed with pip in `venv`. I was able to install outside of the virtual environment, no problem. I then literally copied that file from my Python package library directory and pasted within the same within the `venv`. My hunch is that, becuase my version(s) of Python are Anaconda distributions, that there was something amiss with the path that was being assumed/used. – kuanb Jan 27 '17 at 00:58

score 5 · Answer 12 · answered Mar 30 '13 at 09:51

5

Besides installing the required packages, I also needed to manually add PostgreSQL bin directory to PATH.
$vi ~/.bash_profile
Add PATH=/usr/pgsql-9.2/bin:$PATH before export PATH.
$source ~/.bash_profile
$pip install psycopg2

answered Mar 30 '13 at 09:51

xtranophilist

442
7
13

Any idea why this doesn't end up in the default path? – Bret Feb 24 '15 at 00:48
1

I got a error like that how to rectify thisplease help me!!! Command "/usr/bin/python -c "import setuptools, tokenize;__file__='/private/tmp/pip-build-AUbwwG/psycopg2/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-44Va05-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-build-AUbwwG/psycopg2 – vijay Jul 02 '15 at 11:12

score 4 · Answer 13 · answered May 20 '19 at 14:42

Before you can install psycopg2 you will need to install the python-dev package.

If you're working from Linux (and possibly other systems but i can't speak from experience) you will need to make sure to be quite exact about what version of python your running when installing the dev package.

For example when I used the command:

sudo apt-get install python3-dev

I still ran into the same error when trying to

pip install psycopg2

As I am using python 3.7 I needed to use the command

sudo apt-get install python3.7-dev

Once I did this I ran into no more issues. Obviously if your on python version 3.5 you would change that 7 to a 5.

This should be the answer, `sudo apt-get install python-x.x-dev` fixed the issue. — Arbazz Hussain, Jan 06 '20 at 19:57

score 3 · Answer 14 · answered Sep 27 '13 at 15:24

3

I installed Postgresql92 using the RedHat / CentOS repository on PG's downloads site http://www.postgresql.org/download/linux/redhat/

To get pg_config, I had to add /usr/pgsql-9.2/bin to PATH.

answered Sep 27 '13 at 15:24

joedborg

15,097
30
72
112

Nithin · Answer 15 · 2020-11-19T17:59:22.263

3

For MacOS,

Use the below command to install psycopg2, works like charm!!!

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip install psycopg2

edited Nov 19 '20 at 17:59

answered Sep 25 '20 at 06:51

Nithin

67
5

score 3 · Answer 16 · answered Mar 14 '12 at 12:42

3

On windows XP you get this error if postgres is not installed ...

answered Mar 14 '12 at 12:42

Sam Joseph

4,092
4
27
46

are you sure that is right? I installed postgres on my windows machine and I still get that. ? – Saher Ahwal Jun 14 '12 at 05:04
2

Why don't they have that on their site as pre-req to have postgres? – Saher Ahwal Jun 14 '12 at 05:46

score 2 · Answer 17 · answered Sep 26 '12 at 03:31

I've been battling with this for days, and have finally figured out how to get the "pip install psycopg2" command to run in a virtualenv in Windows (running Cygwin).

I was hitting the "pg_config executable not found." error, but I had already downloaded and installed postgres in Windows. It installed in Cygwin as well; running "which pg_config" in Cygwin gave "/usr/bin/pg_config", and running "pg_config" gave sane output -- however the version installed with Cygwin is:

VERSION = PostgreSQL 8.2.11

This won't work with the current version of psycopg2, which appears to require at least 9.1. When I added "c:\Program Files\PostgreSQL\9.2\bin" to my Windows path, the Cygwin pip installer was able to find the correct version of PostgreSQL, and I was able to successfully install the module using pip. (This is probably preferable to using the Cygwin version of PostgreSQL anyway, as the native version will run much quicker).

Manish Gupta · Answer 18 · 2017-02-18T07:36:15.610

2

Psycopg2 Depends on Postgres Libraries. On Ubuntu You can use:

apt-get install libpq-dev

Then:

pip install psycopg2

edited Feb 18 '17 at 07:36

answered Jun 23 '15 at 06:55

Manish Gupta

3,771
9
48
87

It's not a good practice to mix pip packages and apt-get packages. – wswld Aug 06 '15 at 10:06

score 2 · Answer 19 · answered Oct 11 '16 at 02:09

2

On Fedora 24: For Python 3.x

sudo dnf install postgresql-devel python3-devel

sudo dnf install redhat-rpm-config

Activate your Virtual Environment:

pip install psycopg2

answered Oct 11 '16 at 02:09

Rajkumar R

660
1
9
24

score 1 · Answer 20 · answered Dec 21 '14 at 21:33

For lowly Windows users were stuck having to install psycopg2 from the link below, just install it to whatever Python installation you have setup. It will place the folder named "psycopg2" in the site-packages folder of your python installation.

After that, just copy that folder to the site-packages directory of your virtualenv and you will have no problems.

here is the link you can find the executable to install psycopg2

http://www.lfd.uci.edu/~gohlke/pythonlibs/

i tried this and i get psycopg2-2.6-cp34-none-win_amd64.whl is not a supported wheel on this platform. — jayeshkv, Jun 12 '15 at 20:50

score 1 · Answer 21 · answered Jul 01 '15 at 18:19

1

On OpenSUSE 13.2, this fixed it:

sudo zypper in postgresql-devel

answered Jul 01 '15 at 18:19

Elliott

1,151
11
11

Cristian Muñoz · Answer 22 · 2016-04-11T11:18:57.987

1

I could install it in a windows machine and using Anaconda/Spyder with python 2.7 through the following commands:

 !pip install psycopg2

Then to establish the connection to the database:

 import psycopg2
 conn = psycopg2.connect(dbname='dbname',host='host_name',port='port_number', user='user_name', password='password')

edited Apr 11 '16 at 11:18

answered Apr 11 '16 at 08:52

Cristian Muñoz

460
4
8

I got this working with database listed in `psql -l`, host localhost, default database port 5432, user listed with `\du` once you get into psql and guessing the password. – Harry Moreno Apr 18 '17 at 01:46

score 1 · Answer 23 · answered Jul 09 '16 at 09:29

1

In Arch base distributions:

sudo pacman -S python-psycopg2
pip2 install psycopg2  # Use pip or pip3 to python3

answered Jul 09 '16 at 09:29

iraj jelodari

2,312
3
27
42

score 1 · Answer 24 · answered Jan 23 '18 at 12:21

1

if pip is not working than you can download .whl file from here https://pypi.python.org/pypi/psycopg2 extract it.. than python setup.py install

answered Jan 23 '18 at 12:21

Umer

937
10
24

score 0 · Answer 25 · answered Jan 04 '16 at 14:47

0

On Ubuntu I just needed the postgres dev package:

sudo apt-get install postgresql-server-dev-all

*Tested in a virtualenv

answered Jan 04 '16 at 14:47

marcanuy

19,934
8
56
109

score 0 · Answer 26 · answered Feb 24 '17 at 23:35

0

On OSX 10.11.6 (El Capitan)

brew install postgresql
PATH=$PATH:/Library/PostgreSQL/9.4/bin pip install psycopg2

answered Feb 24 '17 at 23:35

iNoob

1,271
2
17
41

On OSX 10.12.3 (Sierra): `brew install postgresql PATH=$PATH:/usr/local/Cellar/postgresql/9.6.2/bin/ pip install psycopg2` – ishandutta2007 Mar 29 '17 at 15:20
On OS X 10.14, this tuned out to be very challenging. See detailed solution here: https://stackoverflow.com/a/57014480/2162844 – Bisonbleu Jul 12 '19 at 22:22

score 0 · Answer 27 · answered Mar 17 '17 at 14:07

0

On OSX with macports:

sudo port install postgresql96
export PATH=/opt/local/lib/postgresql96/bin:$PATH

answered Mar 17 '17 at 14:07

Palimpseste

37
5

score 0 · Answer 28 · answered Jul 10 '19 at 20:48

0

I was having this problem, the main reason was with 2 equal versions installed. One by postgres.app and one by HomeBrew.

If you choose to keep only the APP:

brew unlink postgresql
pip3 install psycopg2

answered Jul 10 '19 at 20:48

Luís De Marchi

935
12
23

score 0 · Answer 29 · answered Jul 23 '19 at 16:11

0

On macOS Mojave make sure you on newest update with Command Line Tools 10.3 - that worked for me - updated it with Software Update, previous version of Command Line Tools on Mojave did not work for me.

answered Jul 23 '19 at 16:11

Radek

1,021
1
17
33

score 0 · Answer 30 · answered Jul 25 '20 at 12:25

0

Make sure Postgres is installed and PATH is updated before running pip install psycopg2

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

answered Jul 25 '20 at 12:25

Deepak Singhvi

645
6
12

score 0 · Answer 31 · edited Aug 22 '20 at 23:58

0

Every time I run into this problem this seems to work for me.

pip install psycopg2==2.7.5

edited Aug 22 '20 at 23:58

Daniel Walker

3,487
3
13
31

answered Aug 22 '20 at 22:56

ds007

27
9

score 0 · Answer 32 · answered May 30 '21 at 02:10

Installation on MacOS

Following are the steps, which worked for me and my team members while installing psycopg2 on Mac OS Big Sur and which we have extensively tested for Big Sur. Before starting make sure you have the Xcode command-line tool installed. If not, then install it from the Apple Developer site. The below steps assume you have homebrew installed. If you have not installed homebrew then install it. Last but not the least, it also assumes you already have PostgreSQL installed in your system, if not then install it. Different people have different preferences but the default installation method on the official PostgreSQL site via Enterprise DB installer is the best method for the majority of people.

Put up the linkage to pg_config file in your .zshrc file by:
export PATH="$PATH:/Library/PostgreSQL/12/bin:$PATH". This way you are having linkage with the pg_config file in the /Library/PostgreSQL/12/bin folder. So if your PostgreSQL installation is via other means, like Postgres.app or Postgres installation via homebrew, then you need to have in your .zshrc file the link to pg_config file from the bin folder of that PostgreSQL installation as psycopg2 relies on that.
Install OpenSSL via Homebrew using the command brew install openssl. The reason for this is that libpq, the library which is the basis of psycopg2, uses openssl - psycopg2 doesn't use it directly. After installing put the following commands in your .zshrc file:
- export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"
- export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
- export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
  By doing this you are creating necessary linkages in your directory. These commands are suggested by brew while you install openssl and have been directly picked up from there.
Now comes the most important step, which is to install libpq using the command brew install libpq. This installs libpq library. As per the documentation

libpq is the C application programmer's interface to PostgreSQL. libpq is a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries.

Link libpq using brew link libpq, if this doesn't work then use the command: brew link libpq --force.
Also put in your .zshrc file the following
export PATH="/usr/local/opt/libpq/bin:$PATH". This creates all the necessary linkages for libpq library .
Now restart the terminal or use the following command source ~/.zshrc.

This works even when you are working in conda environment.

N.B. pip install psycopg2-binaryshould be avoided because as per the developers of the psycopg2 library

The use of the -binary packages in production is discouraged because in the past they proved unreliable in multithread environments. This might have been fixed in more recent versions but I have never managed to reproduce the failure.

score -3 · Answer 33 · edited Oct 06 '19 at 14:40

-3

On windows this is how it works
On the command prompt after installing flask via pip in virtual environment, run this command

>pip install psycopg2

Check this

edited Oct 06 '19 at 14:40

Dulangi_Kanchana

777
5
15

answered Aug 29 '19 at 19:09

Trect

1,662
2
18
32

How to install psycopg2 with "pip" on Python?

33 Answers33

Option 1

Option 2

Debian/Ubuntu

Python 3

Python 2¹

CentOS 6

Linked

Related

How to install psycopg2 with "pip" on Python?

33 Answers33

Option 1

Option 2

Debian/Ubuntu

Python 3

Python 21

CentOS 6

Linked

Related

Python 2¹