Help! AWS has so many different ways to host a PostgreSQL database. How do I know what to use for my project?
At the moment there are at least 4 different ways to host a PostgreSQL database in the AWS cloud. The comparison chart is there to help highlight some of the key differences of each.
- EC2
- RDS
- Aurora
- Serverless (new)
AWS PostgreSQL Comparison
Auto scaling
Pay for what you use
HTTP Data API
Multi availability zone sync
Auto patching
CloudWatch monitoring
Encryption options
Automated backups
Backup / restore to S3
Backtrack
Database Cloning
IAM Authentication
Performance insights
Public access without VPN
Multi master clusters
Run your own tools
Other limitations
Pricing
EC2
none
best when running continuously
RDS
none
Aurora
none
Serverless
Max 10 instances per VPC
best when using low Aurora Capacity Units
References
- Elephant Photo by David Clode on Unsplash
- stgresql Icon by Icon Mafia
