C4W1A1 - Error to connect to postgress

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
,
1

When trying “dbt debug” in step 1.2.4, I get the following error:

The database returned the following error:

Database Error
could not translate host name “de-c4w1a1-rds.cdyiqoaeam46.us-east-1.rds.amazonaws.com” to address: Temporary failure in name resolution

2

Hello @Egonzalez
Please, check the following items:

  1. Make sure you are choosing all the correct settings while creating the Cloud9 environment. Choosing a wrong VPC or subnet can lead to connection errors between components.
  2. Make sure the host variable in the profiles.yml file, does not contain any http:// keyword in the beginning. It should look like this:
    image
    image470×182 5.49 KB
3

Thanks @Amir_Zare for your prompt response !

I just retried this morning (without any change) and connection worked, so I managed to finish the assessment.