I’m migrating my service off of heroku and heroku randomizes the database name when you use a shared postgres. My current workaround is to just connect to the db and rename the table after the import, but it’s kind of a hassle.
You should be able to use an entire DB URL then you can specify the DB name after /
, something like:
postgres://your_local_username:your_local_password@hostname:5432/your_database_name
Sorry, I’m a little confused. Are you saying that I can supply a destination URI?
You can supply a source URL from your Heroku app such as:
flyctl postgres import postgres://your_local_username:your_local_password@heroku_hostname:5432/your_database_name -a YOUR_FLY_APP
Then you’d need to find your Heroku DB name and change your_database_name
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.