It does the job, but aurora postgres lags behind mysql when it comes to features. Failovers are surprisingly slow, too. You're pretty much stuck with cloudwatch for monitoring, which has significant lag.
> aurora postgres lags behind mysql when it comes to features
And performance, on some workloads we tested. I would benchmark write performance very carefully before using Aurora Postgres (Aurora MySQL does not seem to suffer from the same issue on the same workload).
> Failovers are surprisingly slow, too.
The recommendation now is to use RDS Proxy for faster failovers.