When using `fly pg import`, is it possible to specify a destination database name?

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.