I am trying to set up an AWS account that worked smoothly, then copying the RDS data for the PostgreSQL server into JetBrains Datagrip IDE and when I clicked test connection. I get an error.
"[08001] The connection attempt failed. java.net.UnknownHostException: database-1.xxxxxxxxx.us-east-2."
The 'name' field in Datagrip was auto-populated from Host: which I copied from the endpoint.
The 'port' was saved as standard '5432'
The 'user' field came from AWS field Master username under the 'configuration tab'
The 'password' field I set and wrote down in my backup notebook.
The 'URL:' field is showing jdbc:postgresql://database-1.xxxxxxxxx.us-east-2:5432/postgres-1
My driver in Datagrip is showing PostgreSQL and connection type is listed as default.
AWS is not the easiest online platform for SQL but I was able to get this far in about 12 minutes whereas Azure spent an hour and a half just jerking me around with stupid info.
It feels like I am missing something simple.
When I enter "ping -a database-1.xxxxxxxxx.us-east-2.rds.amazonaws.com" into my mac bash CLI I get Request timeout for icmp_seq 0, then Request timeout for icmp_seq 1... so does that mean the IPv4 isn't active even though AWS says it is?
I'm relatively new to online storage, so thanks in advance for your help.
I am following this tutorial for the AWS vs PostgreSQL, but in this tutorial, he references Mysql so I just clicked Postgres instead of MySQL.
https://medium.com/cory-mayfield/linking-amazon-rds-with-jetbrains-datagrip-d5cc0e2f44f4