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
"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.
What is Amazon RDS for PostgreSQL?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
What are the cons of using Amazon RDS for PostgreSQL?
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions
Stores the admin database for the SRX apps - includes an audit log, error tracking, and SRX admin message log.
Will also store PRS rules when refactor is complete.
Rock solid transactional storage of user, purchase and course activity data. During development database dumps were easy to create and download locally for testing.
We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.
Extremely simple, practically a one-click setup.
4 years of experience using Heroku Postgres for data storage and management.
Created several tables for users, brands, deals, campaigns, and tracking.
Using PostGIS to serve GeoJSON data for the Leaflet front-end.