Having PostgreSQL running on a EC2 instance is actually pretty easy to have. The 9.2.24 version has a very stable behavior with a good performance. Review collected by and hosted on G2.com.
So far, I haven't experienced any downsides to having PostgreSQL on AWS. Maybe it comes down to making sure your SQL syntax is compatible with any other DB engines. Review collected by and hosted on G2.com.