Migrating existing data from local postgres to newly deploy Phoenix app on fly

kEND · May 20, 2023, 7:23am

Can I do this from my laptop using fly postgres import ...? (via a tunnel?)
If so, is this an equivalent to a pg_restore ...

dangra · May 20, 2023, 6:56pm

Yes, you can use to migrate local postgres to fly.

It is quite similar, instead of pg_restore it does:

pg_dump -d $SOURCE_POSTGRES_URI | psql -d $TARGET_POSTGRES_URI

If you are curious, the actual code is at

github.com

fly-apps/postgres-importer/blob/5138f66c891748ad42b0d92e5994e03e18086b5a/cmd/migrate/main.go#L135-L150


      
          	dumpStr := fmt.Sprintf("pg_dump -d %s", opts.sourceURI)
          	if opts.noOwner {
          		dumpStr = dumpStr + " --no-owner"
          	}
          	if opts.clean {
          		dumpStr = dumpStr + " --clean"
          	}
          	if opts.create {
          		dumpStr = dumpStr + " --create"
          	}
          	if opts.dataOnly {
          		dumpStr = dumpStr + " --data-only"
          	}
          
          	restoreStr := fmt.Sprintf("psql -d %s", opts.targetURI)
          	cmd := fmt.Sprintf("%s | %s", dumpStr, restoreStr)

kEND · May 20, 2023, 7:39pm

Got it working a few hours ago. Worked great! Thanks!

Topic		Replies	Views
Restoring a local database on fly.io postgres instance Questions / Help	9	3136	November 14, 2023
How copy local postgres db to fly.io? Phoenix postgres , phoenix-files	5	759	March 5, 2024
fly pg import questions Questions / Help postgres	4	524	June 20, 2023
PostgreSQL database import	3	270	May 21, 2023
pg_dump for Dum(p)ies Phoenix	2	2830	January 13, 2023

Migrating existing data from local postgres to newly deploy Phoenix app on fly

Related Topics