AWS RDS for PostgresSQL supports many popular extensions [1]. I wonder if these are activated here or will be in time. One of pg's unfair advantage is its ecosystem.
I have user-triggered batch processing jobs that need PostGIS; Aurora Serverless for pg would be a great fit.
[1] https://docs.aws.amazon.com/fr_fr/AmazonRDS/latest/UserGuide...