If you are thinking to move to Postgres Amazon Aurora instance, make sure you are aware of ..
1. Vendor lock in- it is not open source any more. You are at mercy of your vendor on upgrades etc.
2. It is much expensive than AWS RDS.. about 20%
3. If you have secondary indexes on tables, the write load will be slower
On the other hand, Aurora is advertised to be 5 times faster read performance. Make sure to benchmark your application load.
For Postgresql Support