creating a public postgres AWS database

Question

I'm trying to create a postgres RDS database on AWS that's accessible to the public without the need for SSH tunnelling. This is for development only. I've created a Separate AWS VPC and assigned gateways and two subnets to it. when I created the database I set it to be public. The security group rules are

Inbound(Custom TCP Rule,TCP 5432,0.0.0.0/0) outbound (All traffic,All,All,0.0.0.0/0)

I can't seem to connect to this database with my local pgadmin.

Answer 1

Did you enable your VPC attributes to have DNS hostnames and DNS resolution enabled? These must be set in order for your DB instance to be publicly accessible.

Answer 2

I verified I had at least two subnets which ACLs allowed connection to the internet but one of the subnets wasn't associated to the route, when I added it I was able to connect to it