I am trying to run Postgres SQL on a AWS t2 micro server. I have seen the documentation about changing the config files and opening up 0.0.0.0/32 and ::/0. I have done all of that and still can not connect remotely.
Can this even be done with a micro server?
Is there another setting within AWS I need to change for this server to accept incoming connections?
I am trying to produce a proof of concept so I am keeping it as small as possible.
2
Answers
Ok. I figured out what was wrong. Although I got all the configurations for PostGres done, I had to make an incoming rule in Windows Defender Firewall to open the 5432 port on the server. As soon as I did that, I could connect.
I do this all the time, it works fine with t2.micro. But you also need to set the security group to allow connections from the outside to get in. The normal default SG doesn’t allow it.