Heroku Postgres and Heroku Private Spaces

Last updated 31 May 2018

This article explains considerations for Heroku Postgres provisioning, plans, and connections that are specific to Private Spaces. If you have an existing Heroku Postgres database on the Common Runtime and you want to migrate it into a Private Space, see Migrating Heroku Postgres Databases to Private Spaces.

Heroku Private Spaces are dedicated environments for running applications within an isolated network. This means that every part of an application’s stack, including the dynos, data stores, and third-party add-ons, are contained within this isolated environment.

Heroku Postgres can run within a Private Space or Shield Space with a developer experience similar to that of the Common Runtime. Many of the same CLI commands and web interfaces work identically.

Provisioning

Private and Shield Spaces each have their own set of Heroku Postgres plans that are unique to that types of space. You can provision databases from the hobby, standard, or premium tiers in a Private or Shield space in us-east-1 or eu-west-1 but those addons will not be automatically networked with your private space.

Create a new database

Many buildpacks provision a database as part of the Heroku build process. If you create an app within a Private or Shield Space, the smallest available private or shield plan is used by default when provisioning. See below for full lists of available private and shield tier plans.

Private Heroku Postgres databases can be provisioned via the CLI:

$ heroku addons:create heroku-postgresql:private-4 -a private-sushi

Depending on the region and the type of database being created, the provisioning process can take up to 10 minutes before the database is available for use.

Private Tier Plans

Heroku Postgres offers a set of plans for Private Spaces. The private tier is designed for production applications that can tolerate up to 15 minutes of downtime in any given month. All private-tier databases include:

• No row limits
• Increasing amounts of in-memory cache
• Fork and follow support
• Rollback up to 7 days
• Database metrics published to application log stream
• High availability
• Automatic encryption-at-rest of all data written to disk.

Shield Tier Plans

Heroku Postgres offers a set of plans for Shield Spaces. The shield tier is designated for production applications that can tolerate up to 15 minutes of downtime in any given month. All shield tier database include:

• No row limits
• Increasing amounts of in-memory cache
• Fork and follow support
• Rollback
• Database metrics published to application log stream
• High availability
• Automatic encryption-at-rest of all data written to disk.

Shield tier databases differ from private tier databases and can only be used in conjunction with a Shield Space. Shield Heroku Postgres databases are meant for situations where meeting compliance is a goal of your application and business. Shield databases also have the following feature sets and restrictions:

• Non-TLS connections from dynos to shield databases are not possible. Encrypted connections are always enforced.
• Dataclips cannot connect to shield databases
• shield databases do not allow connections via heroku pg:psql from outside the Private Space
• Direct access via “Trusted IPs” is not allowed for shield databases from outside the Private Space
• shield databases are monitored by additional intrusion detection and host scanning mechanisms
• PGBackups will not work with shield databases

Connecting to shield database via terminal

Heroku CLI command line tools like heroku pg:psql will not work when connecting to the database from your local machine because arbitrary ingress rules aren’t allowed. Instead, a database connection should be made via a Heroku Dyno assuming that the primary database is using the DATABASE_URL config var:

$ heroku run bash
Running bash on ⬢ sushi... up, run.3032 (1X)

~ $ psql $DATABASE_URL
psql (9.6.1, server 9.6.2)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

d8vbabiotc9412=>

Connecting to the database

All connections to a private database must be made with TLS/SSL. See the connection documentation for your language in the main Heroku Postgres article.

Connections to a database instance with a private plan can only be made within a private space. Connections cannot be made from other private spaces (and private space databases cannot be attached across space boundaries), or from the common runtime.

If you need to be able to connect to a database from a different private space or from the Common Runtime, you may want a database instance with a non-private plan, which will live in the Common Runtime.

External connections

Using the CLI

Unlike the Heroku Postgres databases in our hobby, standard, and premium tiers, private and shield databases cannot be directly accessed via a local computer.

For access to a private plan Heroku Postgres database, you can use heroku pg:psql. This ensures that you have the correct authorization to connect to the database across the isolated network boundary.

For access to a shield plan Heroku Postgres database, you cannot use heroku pg:psql and can only access the database via a dyno in your shield space.

Trusted IPs for data

Trusted IPs for data are a feature of Private Plans in Private Spaces. Databases in Shield Private Spaces cannot use Trusted IPs.

If a direct connection must be made to a Heroku Postgres private plan database from outside the private space boundary, the Trusted IPs feature of Private Spaces can be used to enable the connection. For Trusted IPs to be used for direct connections, the Private Space must be whitelisted by Heroku to enable the functionality. An email can be sent to postgres@heroku.com to discuss use cases and ability to have your private space included. More details on Trusted IPs for data services (Heroku Postgres, Heroku Redis and Apache Kafka on Heroku) can be found in the Private Spaces documentation.