How copy local postgres db to fly.io?

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