Restore Postgres from local dump

Hi… If this is the legacy Fly Postgres (as opposed to the newer managed postgres) then the first step is to simply check its logs with fly logs -a db-app-name to make sure it isn’t OOMing, running out of disk space, etc.

If not, then it may just be a network limitation. A fellow user was reporting problems with a similarly sized transfer recently. Unfortunately, long-running TCP sessions are prone to getting cut pretty much anywhere along the path through the Internet, :dragon:.

I think the Postgres wire protocol was designed for LANs, originally, but I could be wrong there.

A more reliable approach is to use an Internet-oriented transfer mechanism with compression, like gzip + SFTP or rsync, and then do the pg_restore within an SSH session on the database Machine itself.

Hope this helps a little!