[icheishvili]

Our experience with pg aurora was awful. I cannot recommend it to anyone. Our primary would run out of memory and fail over every few hours and all amazon support had to say is that it’s a known issue.

We ended up adding even more functionality to our audit trigger package (based on a SecondQuadrant fork, https://github.com/icheishvili/audit-trigger) to allow us to get off of aurora. AWS does a good job at locking you in.

[js2]

Here's another recent report of a bad experience with a reply from the Principal Product Manager for Aurora PostgreSQL:

https://www.reddit.com/r/aws/comments/bv70k8/aurora_postgres...

[nwah1]

Other downsides are that it is more expensive than Aurora MySQL and there's no automated upgrade tools.

[jitl]

Came here to echo this. I’ve heard the same story from a few different companies that tried to use Postgres Aurora as their primary database: insurmountable production issues, limited response from Amazon, eventual migration away.

[qatanah]

Very interesting audit trigger. Would like to try it w/ partition table instead of doing separate tables.