`heroku pg:copy` fails after a few `starting copy` logs

TL;DR

Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.

Steps

1. Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. We use curl https://cli-assets.heroku.com/install-ubuntu.sh | sh to install the heroku cli.
2. If heroku pg:copy fails after a few 'starting copy' logs on the latest CLI, one reporter resolved it by downgrading the Heroku CLI to 9.5.1. Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.

When to use

You are seeing this: Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. Use this skill when you run into "heroku pg:copy fails after a few starting copy logs".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: 9.5.1. If you are on something much newer or older, the details may have shifted.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://cli-assets.heroku.com/install-ubuntu.sh

In gh:heroku/cli#3146 (https://github.com/heroku/cli/issues/3146), the reporter ran into this: Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. We use curl https://cli-assets.heroku.com/install-ubuntu.sh | sh to install the heroku cli. The verified resolution: If heroku pg:copy fails after a few 'starting copy' logs on the latest CLI, one reporter resolved it by downgrading the Heroku CLI to 9.5.1. Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.