Need advice about which tool to choose?Ask the StackShare community!
Amazon RDS for PostgreSQL vs Heroku Postgres: What are the differences?
Amazon RDS for PostgreSQL: * Set up, operate, and scale PostgreSQL deployments in the cloud. Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS; *Heroku Postgres:** Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL. Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
Amazon RDS for PostgreSQL and Heroku Postgres can be primarily classified as "PostgreSQL as a Service" tools.
Some of the features offered by Amazon RDS for PostgreSQL are:
- Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.
- DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.
- Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.
On the other hand, Heroku Postgres provides the following key features:
- High Availability
- Rollback
- Dataclips
"Easy setup, backup, monitoring" is the primary reason why developers consider Amazon RDS for PostgreSQL over the competitors, whereas "Easy to setup" was stated as the key factor in picking Heroku Postgres.
According to the StackShare community, Amazon RDS for PostgreSQL has a broader approval, being mentioned in 167 company stacks & 29 developers stacks; compared to Heroku Postgres, which is listed in 74 company stacks and 39 developer stacks.
Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.
Good balance between easy to manage, pricing, docs and features.
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
Pros of Amazon RDS for PostgreSQL
- Easy setup, backup, monitoring25
- Geospatial support13
- Master-master replication using Multi-AZ instance2
Pros of Heroku Postgres
- Easy to setup29
- Follower databases3
- Dataclips for sharing queries3
- Extremely reliable3
Sign up to add or upvote prosMake informed product decisions
Cons of Amazon RDS for PostgreSQL
Cons of Heroku Postgres
- Super expensive2
Sign up to add or upvote consMake informed product decisions
What is Amazon RDS for PostgreSQL?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
What companies use Heroku Postgres?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with Amazon RDS for PostgreSQL?
What tools integrate with Heroku Postgres?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+8
+42
+47+39
+26+25+24
+20