Railway•7mo ago

Migrating from Supabase to Railway Postgres service

Will I see a performance increase if I move from a database hosted on Supabase to the postgres service in Railway. If so, how would I go about transferring the data? Thanks!

24 Replies

Percy•7mo ago

Project ID: N/A

Fragly•7mo ago

You'd probably see less egress cost if you use railway databases since you can use private network which doesn't count towards egress, and I can definitally see it being faster

CodingCactus•7mo ago

Nice, any idea how to move the data over?

Brody•7mo ago

pg_dump and pg_restore

CodingCactus•7mo ago

Why can't i connect to the private url?

CodingCactus•7mo ago

this is during the build stage if that matters

Brody•7mo ago

is that during build? if so, the private network is not available during build

CodingCactus•7mo ago

oh ok so much better 😊

CodingCactus•7mo ago

before:

CodingCactus•7mo ago

after:

Brody•7mo ago

are you using the private url during runtime?

CodingCactus•7mo ago

yeah

Brody•7mo ago

awsome!

CodingCactus•7mo ago

just moved my db migration stuff to the start command instead of the build command

Brody•7mo ago

yeah thats a good compromise, but make sure you use a healthcheck so that railway knows when your app has actually started! https://docs.railway.app/deploy/healthchecks

CodingCactus•7mo ago

oooh ok

CodingCactus•7mo ago

am i doing it wrong

Brody•7mo ago

haha nope, known issue one sec until the webui is fixed you would have to set the healthcheck path in a railway.json file, put this in said file at the root of your project

{
  "$schema": "https://schema.up.railway.app/railway.schema.json",
  "deploy": {
    "healthcheckPath": "/ping"
  }
}

{
  "$schema": "https://schema.up.railway.app/railway.schema.json",
  "deploy": {
    "healthcheckPath": "/ping"
  }
}

CodingCactus•7mo ago

ok thanks! any eta on the fix?

Brody•7mo ago

ill try to push the team to get it fixed by eod monday (i dont work for railway)

CodingCactus•7mo ago

lol thanks, i'll probably just wait then not planning on redeploying before then

Brody•7mo ago

updating the health check from the ui would redeploy fwiw

CodingCactus•7mo ago

i set it by clicking the button directly with js rather than my mouse

Brody•7mo ago

haha out of all the reports I've seen of this issue, you are the only one to prevail

Gaming

Programming

Migrating from Supabase to Railway Postgres service