pg_restore

Is remote postgres pg_restore from a local binary dump file supposed to take super long? It took like 7 minutes on my local machine but for remote railway service it has been running for like 12 hours and still only halfway done
6 Replies
Percy
Percy9mo ago
Project ID: 4f8cf47f-9f26-4a9f-833b-5caabb63b493
holy daddy
holy daddy9mo ago
4f8cf47f-9f26-4a9f-833b-5caabb63b493
Adam
Adam9mo ago
How large is the dump file? Railway’s networking can be slow at times, especially when compared to the zero latency you’ll face when uploading locally
holy daddy
holy daddy9mo ago
it's about 6mb
Adam
Adam9mo ago
hm no definitely shouldn’t take that long @Brody any ideas?
Brody
Brody9mo ago
no idea never used postgres