Port Changed Suddenly

[jeremiahlachica]

Bug report

Describe the bug

I have a test project and the port was 6543 previously. Today when I checked https://app.supabase.io, it changed to 5432. I'm not sure what happened. Is this a bug?

[dragarcia]

Hi @jeremiahlachica 👋

Each project actually has two ports available. Port 5432 is for direct connections to the database while port 6543 is for connections to the database through connection pooling via PgBouncer. If you have no need for connection pooling, you can disable it and its port in your project under Database > Connection Pooling and just stick to port 5432.

[jeremiahlachica]

I turned off connection pooling and my code is connecting to 5432 port but I still get error from time to time. The port is changing between 5432 to 6543. Not sure why it does happen.

I have a cloud-function on Firebase that connects to Supabase's Postgres using Prisma for queries. I get this error on my cloud-functions:

@dragarcia Do you have idea?

[dragarcia]

Could you send a support ticket over at app.supabase.io/support/new with regards to this? We'll then take a look to find out what could be happening.

[jeremiahlachica]

Will do. Thanks @dragarcia