I'm not sure what postgres has to do with generating a domain? perhaps you are misunderstanding something, could you provide more context?

n/a

psql -h postgres-production-c626.up.railway.app -p 8080 -U railway -d railway
psql: error: connection to server at "postgres-production-c626.up.railway.app" (35.213.158.48), port 8080 failed: Operation timed out
Is the server running on that host and accepting TCP/IP connections?

you need to use a TCP proxy for databases

Before I look how to do that, I'm trying to reset my umami password and they're saying I have to do it in the DB. Is there a quicker way? Tried the CLI tools, but that's not going to plan either lol (% railway connect

Select service Postgres
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "railway" does not exist)

they are correct, you would need to access the database to do that, and to access the database you need to use the tcp proxy

adding a TCP proxy is covered in the template overview

Ok, will have a look there. Thanks 🙂

Hmm, not sure why this isn't working still. I added the 5432 TCP proxy, redeployed with new settings. psql -h roundhouse.proxy.rlwy.net -p 35459 -U railway -d railway
psql: error: connection to server at "roundhouse.proxy.rlwy.net" (35.213.135.65), port 35459 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

show me a screenshot of your public networking please

and 5432 is set as a variable

what is the start command in use?

/bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432"

That's just the template default I think

yep that's correct, that's what I've set it to, just needed to make sure it wasn't removed or modified

please send the deployment logs for postgres -

1265896722161340426
1265896722521915453

are you perhaps behind a firewall of some kind? hotel, work, school, etc

no, using my phone's hotspot

ISP firewall?

With the CLI tools, using railway connect should work regardless right?

No firewall afaik

No, the cli simply calls out to psql with pre defined flags

don;t have any issues connecting to anything

most things don't run on port 35459

nmap -p 35459 roundhouse.proxy.rlwy.net
Starting Nmap 7.95 ( https://nmap.org ) at 2024-07-25 13:14 AWST
Nmap scan report for roundhouse.proxy.rlwy.net (35.213.135.65)
Host is up (0.29s latency).
rDNS record for 35.213.135.65: 65.135.213.35.bc.googleusercontent.com

PORT STATE SERVICE
35459/tcp open unknown

Nmap done: 1 IP address (1 host up) scanned in 0.71 seconds

can you re-deploy (not restart) the database?

ok

hmm, seems something is working

we like when things work!

Ok, I might have to update psql from 14 to 15 too.

I have too many templates to remember, what version of Postgres is in use for umami?

15 alpine

but also, you can deploy dbgate into the project and use that to manage your database, I've used dbgate to reset a password on umami before with great success

Right, now me and chatgpt are going to figure this one out https://github.com/umami-software/umami/discussions/2483 <:poggers:720701334659268700>

with dbgate you can just go in and update that value and done

where do I set that up? Variables?

Or just deploy that on the same instance?

you simply deploy the dbgate template

yeah, playing with it now

fkn hell, remind me not to lose my umami password again lol

time to start using a password manager

but hey, as long as you've done it once the second time will be easy

I do, it just didn't save for some reason haha Yeah, best way to learn

sweet, that worked!

Thanks for the help

Should I delete the logs etc from here? Looks like it's not provate

it's not private, but nothing sensitive was shared