Two months ago, I followed a tutorial to deploy a Phoenix app, say my-app, using flyctl launch; which, asked me if I wanted to create a Postgres database, and I said Yes, and it created my-app-db. Now, I’m relearning Fly, and I want to issue a pg_dump command and retrieve the backup file. I’ve sear…

pg_dump for Dum(p)ies

belgoros January 13, 2023, 2:46pm 3

Is it possible to do the inverse operation, - restore a FLY.io DB from a local dump file? (see How to execute a DB dump created from Heroku PG database). Thank you.

Topic		Replies	Views
How to execute a DB dump created from Heroku PG database Questions / Help postgres	5	659	January 25, 2023
How can I create a database dump? Questions / Help postgres	3	1814	November 16, 2022
How copy local postgres db to fly.io? Phoenix elixir , postgres , phoenix-files	5	1138	March 5, 2024
Restoring a local database on fly.io postgres instance Questions / Help	9	3682	November 14, 2023
pg_dump for postgres Questions / Help postgres	2	846	March 15, 2022