Amazon RDS for PostgreSQL vs Heroku Postgres

Need advice about which tool to choose?Ask the StackShare community!

Amazon RDS for PostgreSQL

808
599
+ 1
40
Heroku Postgres

487
314
+ 1
38
Add tool

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.

Advice on Amazon RDS for PostgreSQL and Heroku Postgres

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.

See more
Replies (2)
David Weinberg

Good balance between easy to manage, pricing, docs and features.

See more
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 46.4K views

DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Amazon RDS for PostgreSQL
Pros of Heroku Postgres
  • 25
    Easy setup, backup, monitoring
  • 13
    Geospatial support
  • 2
    Master-master replication using Multi-AZ instance
  • 29
    Easy to setup
  • 3
    Follower databases
  • 3
    Dataclips for sharing queries
  • 3
    Extremely reliable

Sign up to add or upvote prosMake informed product decisions

Cons of Amazon RDS for PostgreSQL
Cons of Heroku Postgres
    Be the first to leave a con
    • 2
      Super expensive

    Sign up to add or upvote consMake informed product decisions

    No Stats

    What is Amazon RDS for PostgreSQL?

    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.

    What is Heroku Postgres?

    Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use Amazon RDS for PostgreSQL?
    What companies use Heroku Postgres?
    See which teams inside your own company are using Amazon RDS for PostgreSQL or Heroku Postgres.
    Sign up for StackShare EnterpriseLearn More

    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

    DockerAmazon EC2Scala+8
    6
    2717
    GitHubPythonReact+42
    49
    40767
    GitHubPythonNode.js+47
    55
    72369
    GitHubPythonSlack+25
    7
    3167
    GitHubPythonDocker+24
    13
    17024
    What are some alternatives to Amazon RDS for PostgreSQL and Heroku Postgres?
    JavaScript
    JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such as node.js or Apache CouchDB. It is a prototype-based, multi-paradigm scripting language that is dynamic,and supports object-oriented, imperative, and functional programming styles.
    Git
    Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency.
    GitHub
    GitHub is the best place to share code with friends, co-workers, classmates, and complete strangers. Over three million people use GitHub to build amazing things together.
    Python
    Python is a general purpose programming language created by Guido Van Rossum. Python is most praised for its elegant syntax and readable code, if you are just beginning your programming career python suits you best.
    jQuery
    jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML.
    See all alternatives