Postgres Data UI Not Loading

robert_arellano
HOBBY

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

9 months ago

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

+11

robert_arellano
HOBBY

9 months ago

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

brody
EMPLOYEE

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

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

9 months ago

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

+11

robert_arellano
HOBBY

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

9 months ago

Happy to help!

Status changed to Solved brody • 9 months ago