Postgres Database Connection
jlhsolutions
FREEOP

10 months 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

0 Replies

brody
EMPLOYEE

10 months ago

hello, did you need access to the database?


jlhsolutions
FREEOP

10 months 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.


brody
EMPLOYEE

10 months ago

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

1336898791491506200


jlhsolutions
FREEOP

10 months ago

Thank you! I can see the tables now.

1337134517227622400


jlhsolutions
FREEOP

10 months 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

10 months ago

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

1337134958837235700


medim
MODERATOR

10 months ago

are the services working?


medim
MODERATOR

10 months ago

if so, must be a visual bug


jlhsolutions
FREEOP

10 months ago

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


brody
EMPLOYEE

10 months ago

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


jlhsolutions
FREEOP

10 months 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!


brody
EMPLOYEE

10 months ago

no problem, thanks for asking!


brody
EMPLOYEE

10 months ago

!s


Status changed to Solved brody 10 months ago


Loading...