How to connect pgAdmin with remote supabase [1080p]

[@german2043]

Thanks! it works. Im going to try it with my project team all at once but at least one at the time it works :p!

[@freddychamorro4703]

tks, I had made a mistake with the database name. its postgres not the project name. tks again

[@kamil_supabase_enjoyer]

Happy to help :)

[@e.b.9178]

Thank you sooooooo much!

[@aysekalkan8192]

Thank you really helpful :)

[@Joshua_Udo]

Thanks for this video!

[@nm318]

HI! Thanks for the video! I followed your instructions but keep getting an error message that says "Unable to connect to server: connection failed: received invalid response to GSSAPI negotation: S". I tried yesterday and today in case there was a aserver issue and have not been able to connect. Any thoughts on what this could mean? I'm an old elephatSQL user looking for a new, friendly platform and read good things about supabase. Any help from you or anyone else would be greatly appreciated.

[@kamil_supabase_enjoyer]

Hi :) Great to have you on board. I asked ChatGPT about your problem and here is result:
The error you're encountering, "connection failed: received invalid response to GSSAPI negotiation," can occur when trying to connect to a PostgreSQL instance that requires certain authentication methods or when there is a mismatch in how the connection is being initiated.
Here are some potential solutions:
1. Ensure SSL Mode is Set Correctly
Supabase usually requires SSL to connect, and pgAdmin needs the correct SSL configuration to avoid connection issues.
In pgAdmin, when setting up your connection, go to the Connection Tab.
Under SSL Mode, select require or another SSL option depending on Supabase's requirements.
You can also set this in the Advanced Tab under sslmode as require.
2. Modify the Hostname
If you are using a Supabase-provided URL, ensure that:
You are using the correct hostname (e.g., your-instance.supabase.co).
Do not prefix the hostname with or . Only the raw hostname should be used.
3. Check the Port
Supabase usually uses the PostgreSQL default port 5432. Ensure you are connecting to the right port:
Port: 5432
4. Ensure GSSAPI is Disabled (Optional)
If you don't need GSSAPI for authentication (which is often the case for Supabase connections), you can disable it explicitly:
In the Connection Tab, under Username/Password, ensure you're using the proper credentials for your Supabase database.
Alternatively, in the Advanced Tab, ensure that gssencmode is set to disable if GSSAPI is unnecessary for your connection.
5. Firewall or Network Configuration
If pgAdmin is running locally and you're connecting to a remote Supabase instance, ensure that your local machine can access the instance. This may involve:
Checking firewall rules or any security group configurations on the network.
Verifying that your local IP or machine is allowed to connect to the Supabase instance.
6. Check PostgreSQL User and Role Permissions
Ensure that the PostgreSQL user you're using has the correct roles and permissions to connect from an external IP or pgAdmin.
7. Connection Timeout
Sometimes this error can result from a timeout. Ensure that your Supabase instance is running and accessible.

[@ayami123]

thank you but how to connect using password in nodejs ?
I always get Connection terminated unexpectedly

[@kamil_supabase_enjoyer]

I have no idea how to do it in nodejs. You need to ask someone who uses Node.js

[@drmoyssine]

Thanks for the video. Is it possible to connect a remote Supabase interface to a local Pg database?

[@kamil_supabase_enjoyer]

Can you explain it a little bit more? I cant understand what you wanna know.

[@drmoyssine]

@@kamil_supabase_enjoyer I would like to either 1) connect a selfhosted pg to Supabase or 2) Install Supabase on my vps both of which I'm struggling to achieve 😂

[@kamil_supabase_enjoyer]

@@drmoyssine I dont have any experience with that but maybe @activenode can help you.

[@mahmoudalkateb2008]

hello, did you find any guide on that please if so can you please share it with me

[@adrplex9994]

thank you! info that save my life. It's posible create roles from pgAdmin to remote supabase ? Saludos desde ECU 🇪🇨

[@kamil_supabase_enjoyer]

I think that you should use migrations files for this. Take a look on Supabase official video about migrations :)

[@erikrodriguez8383]

Can you show how to backup remote supabase with pgadmin?

[@kamil_supabase_enjoyer]

I think that supabase CLI is the best for this job.