Can't install psycopg2 using conda install psycopg2

[ale_aleivaar]

Hi,

I want to install the psycopg2 module for Jupyter Notebook. I followed the instructions in the Project - PostgreSQL Installation mission.

I attach a picture of my the conda shell. Is the problem my python version?

[alegiraldo666]

Hi @ale_aleivaar
Yes, it looks like the problem is your python version. Try using the command conda instal python=3.8 and then conda update --all to update all the packages. I think after that it should work

Good luck!

[ale_aleivaar]

Hi, @alegiraldo666,

I solved this problem by installing the psycopg2 in the conda command line using this:

pip install psycopg2

Then added the password parameter in jupyter notebook for variable conn. The password is set when installing PostgreSQL.

conn = psycopg2.connect(dbname=“postgres”, user=“postgres”, password="******")

Hope this information is of help to someone because it seems that I was not the only one. Here is a related post on the same issue.

Conda install psycopg2 failing (PostgreSQL set up)

hi @Simmy14 I am assuming you haven’t tried this. In case, you have then we will look for other solutions. In case you haven’t, try once logging in “pg Admin4” from the start menu under PostgreSQL 12 folder. It will prompt you for a password. You will get this window. [image] Try to reset/set-up the master password. Once you are done, come back to Jupyter notebook and add a parameter for password and supply the password you have set. (I have version 4.18 and it didn’t ask me any password w…