Issue connecting to Postgres SQL on AWS T2 micro server.

huangapple go评论42阅读模式
英文:

Issue connecting to Postgres SQL on AWS T2 micro server

问题

我正在尝试在AWS t2微型服务器上运行Postgres SQL。我已经看过更改配置文件和开放0.0.0.0/32和::/0的文档。我已经做了所有这些,但仍然无法远程连接。

微型服务器是否能够实现这个目标?
在AWS中是否需要更改其他设置以使此服务器接受传入连接?

我正在尝试制作一个概念验证,所以尽量保持它尽可能小。

英文:

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.

答案1

得分: 1

我一直都这样做,对于 t2.micro 是有效的。但你还需要设置安全组以允许外部连接。正常的默认安全组不允许这样做。

英文:

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.

答案2

得分: 0

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.

英文:

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.

huangapple
  • 本文由 发表于 2023年5月18日 10:49:22
  • 转载请务必保留本文链接:https://go.coder-hub.com/76277406.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定