Install psycopg2 on Ubuntu

PythonPostgresqlUbuntu

Python Problem Overview

I'm trying to get the python postgres client module installed on Ubuntu 12.04. The guidance is to do the following:

apt-get install python-psycopg2

However, apt says that the package can't be located.
I'm keen to install this through apt. Is this part of another package that I can install?

Python Solutions

Solution 1 - Python

This works for me in Ubuntu 12.04 and 15.10

if pip not installed:

sudo apt-get install python-pip

and then:

sudo apt-get update
sudo apt-get install libpq-dev python-dev
sudo pip install psycopg2

Solution 2 - Python

Using Ubuntu 12.04 it appears to work fine for me:

jon@minerva:~$ sudo apt-get install python-psycopg2
[sudo] password for jon: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Suggested packages:
  python-psycopg2-doc
The following NEW packages will be installed
  python-psycopg2
0 upgraded, 1 newly installed, 0 to remove and 334 not upgraded.
Need to get 153 kB of archives.

What error are you getting exactly? - double check you've spelt psycopg right - that's quite often a gotcha... and it never hurts to run an apt-get update to make sure your repo. is up to date.

Solution 3 - Python

Use

sudo apt-get install python3-psycopg2

for Python3 )

Solution 4 - Python

This worked for me:

pip install psycopg2-binary

Solution 5 - Python

I updated my requirements.txt to have psycopg2==2.7.4 --no-binary=psycopg2 So that it build binaries on source

Solution 6 - Python

According to the official documentation https://www.psycopg.org/install/

sudo apt install python3-dev libpq-dev
pip install psycopg2

Solution 7 - Python

I prefer using pip in case you are using virtualenv:

  1. apt install libpython2.7 libpython2.7-dev
  2. pip install psycopg2
Categories
Recommended Python Solutions
Recommended Postgresql Solutions
Recommended Ubuntu Solutions

Previous Solution:

Twitter Bootstrap add active class to li

JqueryMenuTwitter Bootstrap

Next Solution:

Fragment add or replace not working

JavaAndroidAndroid Fragments

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionMattView Question on Stackoverflow
Solution 1 - PythonRenato PradoView Answer on Stackoverflow
Solution 2 - PythonJon ClementsView Answer on Stackoverflow
Solution 3 - PythonIlya SheroukhovView Answer on Stackoverflow
Solution 4 - PythonMartin AlexanderssonView Answer on Stackoverflow
Solution 5 - Pythonazhar22kView Answer on Stackoverflow
Solution 6 - PythonakppView Answer on Stackoverflow
Solution 7 - PythonnoomzView Answer on Stackoverflow