Check your Amazon EC2 security groups for inbound rules that allow unrestricted access (i.e. 0.0.0.0/0 or ::/0) on TCP port 5432 in order to reduce the exposure to security risks and protect the PostgreSQL database server instances associated with your security groups. TCP port 5432 is used by the PostgreSQL Database Server, an open-source object-relational database system (RDBMS) well known for reliability, feature robustness, and performance.
This rule can help you with the following compliance standards:
- PCI
- APRA
- MAS
- NIST4
For further details on compliance standards supported by Conformity, see here.
This rule can help you work with the AWS Well-Architected Framework.
This rule resolution is part of the Conformity Security & Compliance tool for AWS.
Allowing unrestricted inbound access on TCP port 5432 (PostgreSQL Database Server) via Amazon EC2 security groups can increase opportunities for malicious activities such as hacking, brute-force attacks, DDoS, and SQL injection attacks.
Audit
To determine if your Amazon EC2 security groups allow unrestricted PostgreSQL access, perform the following operations:
Remediation / Resolution
To update the inbound rule configuration for your Amazon EC2 security groups in order to restrict PostgreSQL Database Server access to trusted entities only (i.e. authorized IP addresses and IP ranges, or other security groups), perform the following operations:
References
- AWS Documentation
- Amazon EC2 security groups for Linux instances
- Work with security groups
- Security group rules for different use cases
- Authorize inbound traffic for your Linux instances
- AWS Command Line Interface (CLI) Documentation
- ec2
- describe-security-groups
- revoke-security-group-ingress
- authorize-security-group-ingress
Unlock the Remediation Steps
Free 30-day Trial
Automatically audit your configurations with Conformity
and gain access to our cloud security platform.
You are auditing:
Unrestricted PostgreSQL Access
Risk Level: Medium