CODEWITHSUNDEEP
rpostgresqlamazon-web-servicesamazon-rdsaws-security-group
ForceLeft415
ForceLeft415

Reputation: 299

Connecting to Amazon AWS PostgreSQL database from R session

I have a database instance running on Amazon AWS. I use the RPostgreSQL package to connect my R session to my AWS database.

My issue is that every time I attempt to connect to my database instance after not having done so for a while, I get a "Connection timed out" error.

I can then use a browser to go to my AWS Console, edit the Inbound and Outbound rules for my security group to allow my IP Inbound & Outbound access. Then I can connect again just fine.

But then if I don't work on my database for a day or two, when I try to connect to my DB, it doesn't work, and the permissions for Inbound/Outbound access no longer match my IP address (which I'm sure is the cause of the problem).

So... is my IP address changing? Or are the edits I'm making to my security group's inbound/outbound permissions not being saved correctly?

To be clear, here's the order of events of how things have been going:

This isn't a debilitating problem, it's just extremely annoying to have to re-do my security settings every time I want to connect to my AWS DB.

Thanks in advance for any help you can provide!

Upvotes: 1

Views: 343

Answers (1)

Sudhendu
Sudhendu

Reputation: 405

It depends, but most possibly it seems to be that your IP is changing. Most of the ISP have Dynamic IP allocation, which means the IP can change if the router is restarted.

It is hence recommended to use DNS name instead of IP address in the security group setting.

It is easier to note down your IP address and check back after two days. Can you see your IP address which you added two days ago in the Security Group page? If yes, you can just goto google "what is my IP" and see if both the values are same. Security Group (SG) setting does not get refreshed or changed on it's own(unless you are allocating a new Security Group).

One more thing you can try. Allow all connection (0.0.0.0) just to test. After two days or so, try again. If it works, it means there is issue with the IP address changing.

Upvotes: 1

Related Questions