Postgres Database Connection
jlhsolutions
FREEOP

a year ago

Hi everyone,

I am brand new to using Railway. I discovered it in a YouTube video. I setup my project using the n8n with workers template from Jack. I had a few issues but seemed to have figured most out.

Now the issue I have having is this.

In the Postgres deployment, I had this error in the Data tab (image #1). I managed to fix this by adding in the couple of variables and using the values as I found in another topic.
I got here (image #2). The Database Connection just spins. After searching
PGUSER=${{POSTGRESUSER}} PGPASSWORD=${{POSTGRESPASSWORD}}
PGDATABASE=${{POSTGRES_DB}}

After I added these keys, then I got here (image #2). The Database Connnection just spins. Searching, I found I needed to set a TCP Proxy. So I set that and redeployed. I am still getting this. When I look at the active deployment, it is stuck on Deploy > Running pre-deploy command (image #3).

When I go to the logs for this, I see a bunch of red items, but I can't seem to figure out the issue (image #4).

At this point, I am not sure what else I need to change so I can load the Postgres database.

Thanks for your help!

Project ID: 23a4c3ea-2a7d-406e-883f-9aa11ae22e1fNow, the issue I am having is this.

Solved

13 Replies

a year ago

hello, did you need access to the database?


jlhsolutions
FREEOP

a year ago

Yeah. I would like to be able to back up and export my workflows and excutions as I have it set to only keep them for a while as I had an issue before where the database was to big and crashed and I lost all my stuff.


a year ago

gotcha, your PGHOST variable was wrong, fixed that for you

1336898791491506200


jlhsolutions
FREEOP

a year ago

Thank you! I can see the tables now.

1337134517227622400


jlhsolutions
FREEOP

a year ago

I am curious if this is normal as I have never used railway before. Should this be spinning at this step?

1337134696668332000


jlhsolutions
FREEOP

a year ago

The n8n install has all check marks but it looks like REDIS has the same thing. Maybe its normal?

1337134958837235700


a year ago

are the services working?


a year ago

if so, must be a visual bug


jlhsolutions
FREEOP

a year ago

Yes everything seems to be working fine. Just wasn't sure if this would cause issues down the road.


a year ago

yep just a visual bug, we have a ticket but its low priority since its purely visual


jlhsolutions
FREEOP

a year ago

Ok great! I won't worry about it. Just new to this service so I didn't want to get too much setup and then find out things aren't working!


a year ago

no problem, thanks for asking!


a year ago

!s


Status changed to Solved brody about 1 year ago


Loading...