Topics

Railway•9mo ago

Migrating database to railway

Hi, I'm trying to migrate a project to railway and initialize/populate a postgre database with content. I did this (naively) by django dumpdata (on previous instance) and loaddata (through railway cli). This approach, however, is painfully slow. Is this expected? According to metrics it's running around 3-5kbps. There must be a better way? Project id: 6e8bbf6b-235b-4f1b-903a-714c7d612be7

4 Replies

Percy•9mo ago

Project ID: 6e8bbf6b-235b-4f1b-903a-714c7d612be7

Brody•9mo ago

you could try pg_dump and pg_restore?

R•9mo ago

Thanks - this was much faster. (for posterity) the restore didn't work well if it was done after the django app was deployed, needed to manually drop all the tables and --no-owner

Brody•9mo ago

awesome!

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Sleeping service not waking in response to POST on internal networkHi All, Project ID: f54d62f5-02ea-4819-9882-dd03c6717a60 I have a public backend with FastAPI wi Transfer database to another Railway.appI want to transfer database to other clint account with full data init. Help me.Already upgraded to paid Hobby plan, but still limitedHello, I upgraded to paid hobby plan (and verified that the invoice was paid), but my deployment is Timed out error connecting backend to MySQL databaseHey guys I'm at the last hurdle for this website if anyone could help I'd really appreciate it http /bin/bash: line 1: gunicorn: command not foundso even after proper requirements and proper template I'm getting this error in the deploy logs. Wha how can i deploy in free trial?deployment error 🙂Question about metricsHello, I know you can view metrics on the dashboard of the project, but I was wondering if it's poss How to download mysql database to use it in my local?Title.. i really do not know how to do it, if anyone can help me please, thanks since now.how do i find a command installed with nixpacks?one of the apps i've deployed has a dependency on `pg_dump` which i am able to install by adding `po Service with deployment removed still consumes memoryProject ID: 469de9a8-9b00-491b-8798-ca03699b97ab Service ID: 2e64dcf3-708d-4549-bae4-2e0bf5e0083f