Why Can't My App Connect to My Database?

A beginner's guide to the 4 checks on AWS: security group, PostgreSQL listening, pg_hba.conf, and the password. Read the error message and it tells you which one failed.