How copy local postgres db to fly.io?

Phoenix
, ,
1

I’m evaluating fly.io deployment of my phx app. Is there an easy way to copy my local postgres db to my fly.io db?

2

You can use fly proxy to connect to it from your local machine and move the data

3

Thanks for your response. What specifically do I do after connecting via the proxy? I don’t see any info on that in the docs that you referred me to.

4

Use whatever command-line or GUI tool to export your local database, connect to fly database and use same tool to run it. Same process as moving data between any two databases once you have the proxy connected, so any tutorial should get you going. This one looks promising.

5

There is also fly pg import, you can point it to your local postgres:

fly pg import -a fly-appname-db postgres://USER:PASSWORD@localhost/DBNAME