Unable to install psycopg2 (pip install psycopg2)

python postgresql pip psycopg2
Rakesh Kumar picture Rakesh Kumar · Apr 13, 2018 · Viewed 75.7k times · Source

I'm using MAC and python version 2.7.14

Collecting psycopg2
  Could not fetch URL https://pypi.python.org/simple/psycopg2/: There was a problem confirming the ssl certificate: [SSL: TLSV1_ALERT_PROTOCOL_VERSION] tlsv1 alert protocol version (_ssl.c:661) - skipping
  Could not find a version that satisfies the requirement psycopg2 (from versions: )
No matching distribution found for psycopg2

Answer

ryche picture ryche · Apr 13, 2018

Try this:

pip install psycopg2-binary

Related questions

Libssl and libcrypto causing dyld: Library not loaded: /usr/lib/libpq.5.dylib

I recently uninstalled postgresql and installed pyscopg2 via pip. I know there's some trickery involved with libcrypto and libssl Currently i have them symlinked to: $ ls -lah libssl.* -rwxr-xr-x 1 root wheel 402K Aug 28 11:06 libssl.0.9.7.dylib -rwxr-xr-x 1 root wheel 589K Aug 28 11:06 …

Read More
Can't subtract offset-naive and offset-aware datetimes

I have a timezone aware timestamptz field in PostgreSQL. When I pull data from the table, I then want to subtract the time right now so I can get it's age. The problem I'm having is that both datetime.datetime.…

Read More
DatabaseError: current transaction is aborted, commands ignored until end of transaction block?

I got a lot of errors with the message : "DatabaseError: current transaction is aborted, commands ignored until end of transaction block" after changed from python-psycopg to python-psycopg2 as Django project's database engine. The code remains the same, just don't know …

Read More