This is a temporary database, so I don’t mind sharing credentials. We have setup the following in RDS:
Host and Port and confirming public access
DB Name
Not shown is the username and password, however I am 100% certain that we are inputting the correct username and password into PgAdmin 4 and into python’s psycopg2.connect function.
Failing connection in PgAdmin 4
However, we are failing to connect in both PgAdmin 4 and in python. The database is definitely public, and I am fairly certain that we are inputting the correct parameters. I believe dbname is testdb and not the instance ID etl-test
What could be the issue? The one thing I am not certain about are the VPCs and the VPC security groups… do we need to input these anywhere into python or PgAdmin4 in order to connect?
>Solution :
Its not the issue with pg-Admin or python. Looks like you don’t have proper inbound rules set up.
this blog post might interests you