- Create a security group rule that allows all traffic from 0.0.0.0/0. This will verify whether or not another rule is denying the traffic.
- Verify that the assigned security groups allow traffic from your IP address to port 5432. Verify that PostgreSQL is configured to listen to external traffic and is bound to the public interface.
- Make sure that you are using an Elastic IP and that it is included within the
postgresql.confconfiguration file. - Stop and start the instance. New security group rules will only take effect after a restart.
You created a new Linux EC2 instance and installed PostgreSQL but you are not able to establish a connection to the server from your local computer. What steps do you take to resolve this issue?
ByNeha S
Feb 10, 2022