Troubleshooting a connection to an Amazon RDS Postgres database over the internet

I'm building a data engineering project, consisting of an ETL pipeline that serves data to a visualisation application (written in Python). One of the first steps to set up the project is to create the database that will hold the data returned from t...