Heroku Postgres | Heroku Dev Center (original) (raw)

• Databases & Data Management
• Heroku Postgres
• Postgres Basics
• Heroku Postgres

English — 日本語に切り替える

Last updated March 11, 2025

Table of Contents

• Understanding Heroku Postgres Plans
• Provisioning Heroku Postgres
• Local Setup
• Using the CLI
• Manage Your Heroku Postgres Database
• Version Support
• Migrating Between Plans
• Connecting to Heroku Postgres
• Monitor Your Heroku Postgres Database
• High Availability
• Maintenance
• Security and Compliance
• Support

Heroku Postgres is a managed SQL database service provided directly by Heroku. You can access a Heroku Postgres database from any language with a PostgreSQL driver, including all languages Heroku officially supports.

In addition to a variety of Heroku CLI commands to manage your database, Heroku Postgres provides a web dashboard, dataclips to share queries, and several other helpful features.

Understanding Heroku Postgres Plans

Heroku Postgres offers a variety of plans, spread across different tiers of service: Essential, Standard, Premium, Private, and Shield. For more information on what each plan provides, see Choosing the Right Heroku Postgres Plan.

Pricing information for Heroku Postgres plans is available on the Heroku Postgres add-on page.

If your app’s requirements eventually outgrow the resources provided by the initial plan you selected, you can upgrade your database to a new plan.

Provisioning Heroku Postgres

For more information about how to provision a Heroku Postgres database, see Provisioning Heroku Postgres..

Local Setup

Heroku recommends running Postgres locally to ensure parity between environments. For more information about how to set up Heroku Postgres to run in your local environment, see Local Setup for Heroku Postgres.

Using the CLI

For more information about managing Heroku Postgres using the CLI, see Managing Heroku Postgres Using the CLI.

Manage Your Heroku Postgres Database

Designating a Primary Database

For more information about designating a primary database, see Provisioning Heroku Postgres..

Sharing Heroku Postgres Between Applications

For more information about sharing your database between applications, see Provisioning Heroku Postgres..

Importing and Exporting Databases

For more information about exporting to or importing from external PostgreSQL databases with PGBackups, see Importing and Exporting Heroku Postgres Databases.

Configure Database Settings

For information about configuring settings on your database, see Heroku PGSettings.

Removing the Add-on

For more information about removing your database add-on, see Provisioning Heroku Postgres..

Version Support

The PostgreSQL project releases new major versions on a yearly basis. Heroku Postgres supports each major version shortly after its release. For more information about version support on Heroku Postgres, see Heroku Postgres Version Support.

For more information about upgrading the version on your database, see Upgrading the Version of a Heroku Postgres Database.

Migrating Between Plans

For more information about upgrading and migrating database plans, see Changing the Plan or Infrastructure of a Heroku Postgres Database.

Connecting to Heroku Postgres

For examples on connecting to Heroku Postgres, see:

• Connecting to Heroku Postgres
• Connecting to Common Runtime Heroku Postgres Databases from an External Resource
• Connecting to a Private or Shield Heroku Postgres Database from an External Resource

Monitor Your Heroku Postgres Database

Performance Analytics

For more information about performance analytics, see Heroku Postgres Performance Analytics.

Metrics Logs

For more information about Heroku Postgres metrics logs, see Heroku Postgres Metrics Logs.

To get started on monitoring your database and best practices, see:

• Getting Started: Monitoring a Heroku Postgres Database
• Heroku Postgres Monitoring Best Practices

High Availability

For more information about high availability on Heroku Postgres, see High Availability on Heroku Postgres.

Maintenance

From time to time, Heroku performs maintenance tasks on a Heroku Postgres database. Typical tasks include updating the underlying infrastructure of the database. For more information, see Heroku Postgres Maintenance.

Security and Compliance

Data Residency

When a database gets provisioned, the data associated with that database is stored within the region in which it’s created. However, some services ancillary to Heroku Postgres and the systems managing the database fleet aren’t located within the same region as the provisioned databases:

• Postgres Continuous Protection for disaster recovery stores the base backup and write-ahead logs in the same region that the database is located.
• Logs for the Common Runtime are routed in the same region the app is running within. For example, logs for an app in the us region gets routed through the us infrastructure.
• Logs for apps in Private Spaces stay within the same region as the space itself. For example, logs for an app in a Tokyo space routes through the infrastructure in Tokyo. You can deploy apps with strict compliance requirements in Shield Private Spaces, which uses Private Space Logging to route logs instead of Logplex.
• You can block the logging of Heroku Postgres queries and errors by using the --block-logs flag when creating the database with heroku addons:create heroku-postgres:....
• PG Backup snapshots are stored in the US. To capture logical backups in another region, see Heroku Postgres Logical Backups.
• Dataclips are stored in the US.

See the Salesforce Infrastructure & Sub-processors document for the list of sub-processors Heroku uses and the list of countries where Heroku data is stored and processed.

Support

Submit all Heroku Postgres support and runtime issues via one of the Heroku Support channels.