Technology1 min read

Introducing Snapshot Migration to Heroku Postgres Advanced

By · Published by Everything Blog

In short

The new `heroku data:pg:migrate` utility simplifies migrations from Postgres Classic to Heroku Postgres Advanced by generating matching destination databases and copying supported configurations. Operations are split into an online preparation stage and an offline snapshot data transfer, which users can schedule within a 24-hour window. Because write operations pause during the final transfer, overall application downtime scales according to the size of the database. Post-migration reports also identify specific unverified items, such as tables missing primary keys, to ensure data integrity.

Key points

  • Operators have up to 24 hours after preparation to schedule the offline snapshot phase th…: Operators have up to 24 hours after preparation to schedule the offline snapshot phase that transfers data and restores constraints.
  • Application downtime scales with the overall size of the database because write operation…: Application downtime scales with the overall size of the database because write operations must be blocked during the final data copy.
  • Post-migration completion reports provide failure explanations and detail unchecked eleme…: Post-migration completion reports provide failure explanations and detail unchecked elements like tables that lack primary keys.

Sources checked by our analysis pipeline: 1

- Last Updated: November 17, 2026

When we announced Heroku Postgres Advanced in October, migration tooling for Postgres Classic databases was the first item on our roadmap. The first part of that tooling is available today: heroku data:pg:migrate

.

heroku data:pg:migrate

is a guided, interactive Heroku CLI workflow that moves a Postgres Classic tier database to Heroku Postgres Advanced. You don’t write dump scripts or copy settings by hand. You decide when the migration starts and we validate the copied data before you switch over.

heroku data:pg:migrate

at a glance

- One guided command: choose a source and destination, then prepare, start and track the migration, all from the Heroku CLI.

- Destination created for you: optionally create the Advanced database during the flow, on the source’s Postgres major version and with networking to match its Private or Shield Space.

- Online preparation: your Postgres Classic database keeps serving traffic while we prepare.

- Downtime on your schedule: start the migration any time within 24 hours of preparation finishing.

- Settings carried over: customized Postgres settings are copied wherever Advanced…

Technology