Why are `heroku pg` commands failing with "Couldn't find that add on"?


When running a heroku pg command (e.g. heroku pg:copy), the command fails with the error message:

Couldn't find that add on


This message gets shown when the CLI can't verify you have access to these two resources, usually because the parameters being used to identify the database(s) are somehow ambiguous.

Instead of using DATABASE_URL for example, you could try looking up the color URL using heroku pg:info (this will be something like HEROKU_POSTGRESQL_TEAL_URL) or the addon name using heroku addons (this will be something like flowing-example-1234). Using one of these more specific identifiers should help to resolve any issues in running the command.