[Superset]: No module named psycopg2

[#1]

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!

[#2 · Accepted solution]

@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

[#3]

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