Heroku Postgres

Managed SQL Database as a Service for all developers.

What is Postgres?

PostgreSQL is one of the world's most popular relational database
management systems. Millions of developers and companies rely on
PostgreSQL as their transactional data store of choice to drive
application health and decision-making. And developers with knowledge
of Oracle or MySQL databases can use their SQL querying experience
to quickly leverage PostgreSQL's capabilities as a fast, functional,
and powerful data resource.

Why Heroku Postgres?

Heroku's Operational Experience, now applied to data

We've taken Heroku's operational expertise of scaling applications,
and integrated useful runtime features for developers worldwide,
and we've applied it to the data stack. Heroku's integration of
managed data services alongside our application runtime provides
a seamless approach to building applications with a solid data
layer built in - all while having complete control of how you want
to build your applications on the Heroku platform.

We know Postgres

We've been running one of the world's largest fleets of Postgres databases
for years, providing us with a deep understanding of how to make it better
for our customers. Whether it's an index that’s not being used,
security patches that have to be applied, or guidance relevant to ensuring
your database is performing well, we’re here to guide you along the way.

Make your data more powerful and manageable

Heroku Postgres helps you maximize your data instead of spending time
on database setup and maintenance. Test new schema migrations, manage
database access levels and protect queries, scale horizontally, and
allow your team to quickly access data. Whether it's features like
Continuous Protection or seamlessly applying the latest security patch,
you can rest easy as your database is being protected by our
behind-the-scenes efforts.

heroku addons:create heroku-postgresql:hobby-dev

Creating heroku-postgresql:hobby-dev on ⬢ sushi... free

Database has been created and is available

Tools to unleash your data's potential

Fork

Forking a database is just like forking source code. Perfectly clone your database with a single command. Test new schema migrations by simply forking your production database and running the new migrations against the fork. Load test by forking and running your testing environment against it.

Follow

Followers are read-only replicas of a database. Followers stay up-to-date with changes to your database and can be queried. Traditionally, setting up and maintaining replication is a difficult and specialized task. But with followers, it just works. Followers provide horizontal scalability by distributing database read traffic.

Credentials and Settings

Managing your data - and who has access to it - is easy with Heroku Postgres. Credentials allow you to set and manage varying access permissions. You can also tune Settings to adjust the way your database is administered.

Heroku Postgres plans

Heroku Postgres is a fully managed, reliable database-as-a-service and powerful suite of tools.

Hobby

Managed Postgres for demos and development.

10K-10M maximum rows

$0 — $9 per month
prorated to the second
You pay only for the time your database is provisioned as a fraction of the month. E.g. in a 30 day month having it provisioned for 2 days will cost you 1/15th of the list price.

Standard

Production-ready Postgres for teams.

4-488 GB RAM

68 GB-3 TB Storage

120-500 Connections

4 Days Rollback

Max Downtime 1 hour/month

Encryption at Rest

$50 — $4,500 per month
prorated to the second
You pay only for the time your database is provisioned as a fraction of the month. E.g. in a 30 day month having it provisioned for 2 days will cost you 1/15th of the list price.

Premium

Managed Postgres for critical applications.

4-488 GB RAM

68 GB-3 TB Storage

120-500 Connections

7 Days Rollback

Max Downtime 15 minutes/month

Encryption at Rest

High Availability

$200 — $8,500 per month
prorated to the second
You pay only for the time your database is provisioned as a fraction of the month. E.g. in a 30 day month having it provisioned for 2 days will cost you 1/15th of the list price.

Simple, flexible Postgres pricing

Scale vertically by choosing from a range of plans. Plans differ based on the portion of data available and optimized on-the-fly in high speed RAM. Scale read performance horizontally by adding read-only followers.

We keep your data safe

Continuous Protection

Continuous Protection keeps data safe. Every change to your data is written to write-ahead logs, which are shipped to multi-datacenter, high-durability storage. In the unlikely event of an unrecoverable hardware failure, these logs can be automatically 'replayed' to recover the database to within seconds of its last known state.

Rollback

Your data can be rolled back with a single command. This can be used to quickly recover from accidentally dropped tables, to conduct an audit of historical data, or for any other case where you need to go back in time. With rollback your data is safe from any situation you could encounter.

Automated health checks

Heroku Postgres databases are constantly monitored to ensure the health of your database. Should any health check fail automated processes are kicked off to restore your database to ideal working order.

High availability

Where application uptime is critical the Heroku Postgres Premium tier and above offers higher availability through automatic failover. We take care of uptime so you can focus on growing your application.

Security and compliance

At Heroku, trust is our number one value. We regularly perform audits and maintain PCI, HIPAA, ISO, and SOC compliance to further strengthen our trust with customers. Learn more by visiting our compliance center.

As our business has rapidly grown, Heroku Postgres has scaled with us. Our Heroku Postgres database is performant, secure, and reliable, and we sleep better at night knowing that Heroku's team is monitoring it for us 24/7. It's allowed us to quickly create a sophisticated development pipeline that would have been difficult otherwise. It's hard to imagine trying to build our business on any other infrastructure.