Can you define "not working"?

Error logs would help

I used as command: migrate -path ./migrations -database "$DATABASE_URL" up

and it says Pre-deploy command failed

Can you provide logs?

It looks like no issues here on the log but it is red

Look at deploy logs

it just gives me Starting Container

Stopping Container

(You sent the build logs)

This are deploy logs I sent you

but I keep previously got it as

railway build crashed and gave /bin/bash: line 1: migrate: command not found

You should be migrating post-build...

There is your error: Railway can't find the migrate command.

It seems that first you need to install their CLI. At this point, I would recommend creating a Dockerfile (you can use AI for this) and then instructing it to install the CLI: .

Just make sure to tell your AI to not run the migrate command inside the Dockerfile and keep the post-deploy command.

Or you can do it by hand if you know how to do it 🙂

ahh knew that I need docker I thought I could let railway to install that before doing the migrate command

It might be possible via environment variables: https://railpack.com/config/environment-variables but I would recommend using a Dockerfile if you can.

yeah might just do the docker at this point

you should be able to do this with railpack!

I'm still improving the documentation here but you should be able to just install that binary you need with mise.

You could try a mise.toml file, but it may not work properly until next week (0.21.0 release)

packages works right now, here's an example: https://github.com/iloveitaly/dreamhost-dns-updater/blob/main/railpack.json

for migrations, you'll want that in your startCommand (builders have no DB access)

mise has a go backend that you can use to install migrate https://mise.jdx.dev/dev-tools/backends/go.html

made it with docker now and added the pre-build command again

on the docker instance added the variable DATABASE_URL and now I get error: no scheme

I really like Railpack. I hope you can improve the documentation on how to do basic things such as this. That's my only reason for recommending a Dockerfile.

Maybe you have to point to some kind of schema file? Not too familar with migrate, give me a minute

I have migration folder with all sql files

found the issue

my dockerfile and railway used diff keyword for postgresql or postgre

so my command is now: migrate -path ./migrations -database "$(echo $DATABASE_URL | sed 's/^postgresql:/postgres:/')" up

it is currently deploying

While humans (and many modern drivers) treat postgres:// and postgresql:// as the same thing, the golang-migrate CLI is very picky. It looks specifically for postgres:// to identify which internal driver to load. When it sees postgresql://, it essentially throws its hands up and says, "I don't know what scheme this is."

@ThallesComH yeah, improved docs needs to happen. There's a list of some more obvious improvements that need to get landed first then I can take some time to really improve the docs, examples, etc.

@ThallesComH Same crap again failed to build. Something is wrong with that process

why there is not documentation anywhere how to do that

Can you send me your Dockerfile?

Wouldn't make sense to create a documentation for each framework IMO, pre-deploy just works in my experience (I'm on NodeJS land btw).

I'm trying now with shellscript

this time it got build but my db is empty

first time successful build of the docker image

Wait, so it deploys successfully but your database is still empty?

funalllyyy

now I get different thing

Starting Container

1/u create_users_table (74.977159ms)

2/u create_plans_table (156.340898ms)

3/u create_monitors_table (230.98548ms)

4/u create_monitor_types_table (303.535058ms)

5/u update_monitors_typeid (383.929834ms)

6/u create_monitor_logs_table (459.396909ms)

7/u create_monitor_phases_table (540.742469ms)

8/u add_phase_id_to_monitors_table (615.202262ms)

9/u update_monitor_logs_phase_id (687.141404ms)

10/u add_role_to_users_table (761.083751ms)

11/u create_password_reset_tokens_table (836.643425ms)

12/u create_monitor_webhooks_table (831.752403ms)

13/u add_type_to_monitor_webhooks_table (821.129856ms)

14/u add_max_webhooks_to_plans (816.539071ms)

15/u create_status_pages_table (816.62487ms)

16/u remove_phase_id_from_status_page_monitors (809.498675ms)

17/u add_slug_and_published_to_status_pages (803.915179ms)

Stopping Container

Starting Container

no change

2026/03/19 17:44:10 Connected to database.

2026/03/19 17:44:10 log retention cleanup failed: failed to connect to user= database=: /tmp/.s.PGSQL.5432 (/tmp): dial error: dial unix /tmp/.s.PGSQL.5432: connect: no such file or directory

For that final error, your client might not be using the database_url environment variable for some reason. IIRC Golang uses a different type of URL for their database clients.

yea getting close to make it all working

FINALLY IT WORKSSS

just changed to use in my db init

connStr := os.Getenv("DATABASE_URL") as I was using my local setup

Thanks for the support and help