question [Superset]: No module named psycopg2 in Support Questions

[Superset]: No module named psycopg2

khouloud_lander — Mon, 19 Sep 2022 18:33:44 GMT

I am trying to add a postgres database to superset. This is my connection URI: postgresql://username:password@localhost/mydatabase.
I keep getting the following error while trying to test connection: No module named psycopg2 !

I made sure I installed this module using pip install psycopg2 in shell but it's still not working!

Re: [Superset]: No module named psycopg2

nbangarwa — Fri, 25 May 2018 22:18:44 GMT

@Khouloud LandariIn HDP superset is installed inside a python virtual environment.

In order to install psycopg2, you will need to run following command -

/usr/hdp/current/superset/bin/pip install psycopg2

Alternatively, We package superset with pygresql and you can change the connection URI to use that -

postgresql+pygresql://user:password@host:port/dbname

Re: [Superset]: No module named psycopg2

khouloud_lander — Mon, 28 May 2018 19:23:18 GMT

Thank you @Nishant Bangarwa! "No module psycopg2" solved!
Though I am getting another error now:
Error: Fatal: no pg_hba.conf entry for host "x.x.x.x", user "x", database "x", SSL off.
Plus, I am not sure about the user & password for my Postgres database