Best way to migrate 9GB of media to/from volume?
macdonjo
PROOP

a year ago

It seems like scp cannot be used on these machines. How exactly do I migrate a .tar.gz or some sort of folder with oodles of images, to/from Railway?

Solved$10 Bounty

Pinned Solution

a year ago

These are the listed size limits.

5000mb should not be the limit.

Regarding transferring the data, I would recommend making a pg_dump, and then using the credentials of the other database to transfer directly from the original. The command to do that is as follow.

pg_dump --dbname=whateveryourdbiscalled --file="dump.sql"

psql whateveryourdbiscalled < dump.sql

You'll need to put all your authentication for the remote database in this second command as well.

Attachments

3 Replies

macdonjo
PROOP

a year ago

Even once you get it there, it says:

Failed to resize volume

Max size of 5000 MB on current plan. Please select a valid size or upgrade

But the next plan up says nothing about limits on volumes. It seems to be hidden.


a year ago

These are the listed size limits.

5000mb should not be the limit.

Regarding transferring the data, I would recommend making a pg_dump, and then using the credentials of the other database to transfer directly from the original. The command to do that is as follow.

pg_dump --dbname=whateveryourdbiscalled --file="dump.sql"

psql whateveryourdbiscalled < dump.sql

You'll need to put all your authentication for the remote database in this second command as well.

Attachments


samgordon

These are the listed size limits. ![](https://station-server.railway.com/attachments/att_01jx5709t9fer8834h82ngt8f4) 5000mb should not be the limit. Regarding transferring the data, I would recommend making a `pg_dump`, and then using the credentials of the other database to transfer directly from the original. The command to do that is as follow. `pg_dump --dbname=whateveryourdbiscalled --file="dump.sql"` `psql whateveryourdbiscalled < dump.sql` You'll need to put all your authentication for the remote database in this second command as well.

macdonjo
PROOP

a year ago

I already transferred the DB, but this is more about static files. I have user uploaded media.


Status changed to Solved chandrika 11 months ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...