Postgres Data UI Not Loading

robert_arellano

HOBBYOP

2 years ago

I have a database that is working correctly with the web server. However, when I try to load the database UI, it gets stuck on the database connection and never fully loads. There are no error messages. I already tried redeploying the database without success.

Solved

7 Replies

brody

EMPLOYEE

2 years ago

You have the TCP Proxy pointing to the wrong internal port.

robert_arellano

HOBBYOP

2 years ago

Hi brody, thanks for your help. I removed the TCP proxy, redeployed and still the same issue.

brody

EMPLOYEE

2 years ago

Hmmm, not too sure why you removed it without adding it back, you need the TCP Proxy to be able to communicate with the database publicly, you just need to point it to the correct port.

tarpagad

HOBBY

2 years ago

I was getting the same error today and had to do this in my prisma to get it work again

: `

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_PUBLIC_URL")
  // directUrl = env("DATABASE_PUBLIC_URL")
}

use the `DATABASE_PUBLIC_URL` directly

brody

EMPLOYEE

2 years ago

Have you redeployed the database since adding the TCP Proxy back?

robert_arellano

HOBBYOP

2 years ago

Yes, I just redeployed after adding the TCP proxy back with the correct port and it's working now! Thank you all for your help.

brody

EMPLOYEE

2 years ago

Happy to help!

Status changed to Solved brody • over 1 year ago

Welcome!