Postgres + net and next.js project
onestyle7
HOBBYOP

10 months ago

Hi, I have a problem connecting postgres to my project, the project is downloaded from github and I want to connect it to postgres, but when I try to connect the only table I have is the migrations table, I don't have any other. I can't find any information about this in the documentation. Project is buidling and deploying correctly till trying to connect to db.

Solved

8 Replies

echohack
EMPLOYEE

10 months ago

It sounds like you're able to connect successfully. I am seeing some errors in your application, so perhaps you don't have your application configured correctly?

You may need to bind to ipv6 and use private networking if you aren't already. https://docs.railway.com/guides/private-networking


Status changed to Awaiting User Response Railway 10 months ago


onestyle7
HOBBYOP

10 months ago

Actually postgress see mmy migrations and says I'cant import data bcs table already exist but i cant see any table in data on postgres
I'm not sure what I'm doing wrong, we are first time trying to deploy app to productionsweat_smile emoji


Status changed to Awaiting Railway Response Railway 10 months ago


echohack
EMPLOYEE

10 months ago

Hey Onestyle,

Unfortunately this is an application level issue and not a problem with Railway so I'm not really able to help here. I'd suggest using a tool like TablePlus to help you better manage and debug your Postgres issues here. https://tableplus.com/


Status changed to Awaiting User Response Railway 10 months ago


onestyle7
HOBBYOP

10 months ago

I see, but localy all works correctly


Status changed to Awaiting Railway Response Railway 10 months ago


echohack
EMPLOYEE

10 months ago

Have you tried connecting to your database using psql or a gui tool like TablePlus to diagnose?


Status changed to Awaiting User Response Railway 10 months ago


onestyle7
HOBBYOP

10 months ago

Yes I tried, locally the db works and everything is correct I tried on psql admin panel and PostgresSQL Explorer. I only have a problem with postgres set on railway. Maybe I should some how import table directly?


Status changed to Awaiting Railway Response Railway 10 months ago


echohack
EMPLOYEE

10 months ago

I'd trust the error here that your database already has these relations and that your application is trying to incorrectly create them. Unfortunately I'm unable to help further as this is an application issue.


Status changed to Awaiting User Response Railway 10 months ago


onestyle7
HOBBYOP

10 months ago

We done it, propably all work good, but the name of the DB was Identity instead of public smile emoji


Status changed to Awaiting Railway Response Railway 10 months ago


Status changed to Solved onestyle7 10 months ago


Loading...