Railway•13mo 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•13mo ago

Project ID: N/A

Fragly•13mo 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

CodingCactusOP•13mo ago

Nice, any idea how to move the data over?

Brody•13mo ago

pg_dump and pg_restore

CodingCactusOP•13mo ago

Why can't i connect to the private url?

CodingCactusOP•13mo ago

this is during the build stage if that matters

Brody•13mo ago

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

CodingCactusOP•13mo ago

oh ok so much better 😊

CodingCactusOP•13mo ago

before:

CodingCactusOP•13mo ago

after:

Brody•13mo ago

are you using the private url during runtime?

CodingCactusOP•13mo ago

yeah

Brody•13mo ago

awsome!

CodingCactusOP•13mo ago

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

Brody•13mo 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

CodingCactusOP•13mo ago

oooh ok

CodingCactusOP•13mo ago

am i doing it wrong

Brody•13mo 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"
  }
}

CodingCactusOP•13mo ago

ok thanks! any eta on the fix?

Brody•13mo ago

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

CodingCactusOP•13mo ago

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

Brody•13mo ago

updating the health check from the ui would redeploy fwiw

CodingCactusOP•13mo ago

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

Brody•13mo 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