Postgres Data UI Not Loading
robert_arellano
HOBBYOP

a year 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

a year ago

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

+11
robert_arellano
HOBBYOP

a year ago

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

brody
EMPLOYEE

a year 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

a year 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

a year ago

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

+11
robert_arellano
HOBBYOP

a year 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

a year ago

Happy to help!

Status changed to Solved brody • about 1 year ago

Loading...