How to disable postgres SSL for windmill.dev deployment?
Hey everyone, I'm trying to deploy windmill.dev on railway but I'm getting an error related to postgres database SSL. Does anyone know how to turn off SSL for postgres on railway cli or creating a custom postgres template without ssl? I appreciate any help or guidance. Thanks!
26 Replies
Project ID:
N/Awhat ssl errors are you getting
I deployed a postgres database on railway and copied the connect link to the windmill .env file prior to windmill deployment, but I still get an error. I think it's because postgres on railway has ssl enabled by default, and windmill doesn't support that.
The error message is: Error: Bad config: DATABASE_URL env var is missing
This is the windmill repo I'm using: https://github.com/windmill-labs/windmill
GitHub
GitHub - windmill-labs/windmill: Open-source developer platform to ...
Open-source developer platform to turn scripts into workflows and UIs. Open-source alternative to Airplane and Retool. - GitHub - windmill-labs/windmill: Open-source developer platform to turn scri...
that error has nothing to do with ssl?
I think because of ssl on that's why windmill can't connect with postgres ? Please advise!
do you have a
DATABASE_URL service variable? https://docs.railway.app/develop/variables#defining-variablesThanks for poiting that out. I totally forgot that. I did and I got this error.
Error: Migrating database: while executing migrations: error returned from database: syntax error at or near "TRIGGER"
Caused by:
0: while executing migrations: error returned from database: syntax error at or near "TRIGGER"
1: error returned from database: syntax error at or near "TRIGGER"
2: syntax error at or near "TRIGGER"
However, when I switched to supabase database, it works beautifully
what version of postgres does windmill need?
postgres 14 I believe
what version of postgres does railway use
postgres 16 I think ?
check please
Just check again. Postgres latest in railway dockerfile so I believe it should be 16
you are deploying postgres from a dockerfile?
from the railway template, not dockerfile
deploy the plugin version of postgres, i think that uses postgres 14
Could you please give me more details on how to get it down as I am not quite fimilar with Dockerfile
has nothing to do with a dockerfile
just deploy the plugin version of postgres, not the template, use the
+ New buttonV1 plugins will soon be going away so please don't rely on it too much. Does windmill just not support the latest version?
Could you please show me know how to deploy a postgres 14 version on Railway?
You can deploy the
postgres:14 docker image and attach a volume to it. If you have the latest postgres deployed, you can remove the source image from the service settings and change it to postgres:14I am quite new to railway abd docker. could you please elaborate with me more on this ? Thank you
deploy the postgres template
instantly cancel the deployment
remove the source image
add this image
ghcr.io/railwayapp-templates/postgres-ssl:14 to the serviceSorry. I tried but I couldn't make it work somehow.
we will add a postgres 14 template soon, which will be a lot easier to use
Thank you so much. I tried to deploy the postgres in railway template (the latest version separated from windmill) and I got this error when I tried to connect to windmill. I believe this is the error related to ssl ??
Error: Connecting to database: error communicating with database: invalid peer certificate: Other(UnsupportedCertVersion)