I've spun up an RDS postgres database in an existing VPC (which has both public and private subnets - connected to a NAT gateway) which I've set as publicly accessible.
I've added the relevant IP addresses to the attached security group, and this has allowed internal access from inside the VPC but not external access.
Struggling to figure out where to start looking for troubleshooting not being able to access the database externally from the safe-listed IPs.
I've run through the amazon troubleshooting guides (is it set to public? does the vpc have internet access inbound and outbound? have you added the right security group and IPs?) but still no luck.
nc: connect to eksdatabase[redacted].amazonaws.com port 5439 (tcp) failed: Connection timed out