Unable to establish a direct connection to the database from pgAdmin.

[bala-goflink]

I've referred to the documentation, and I'm attempting to establish a direct connection to my database from pgAdmin. This is so I can perform a bulk upload of 10 million records into my database. However, I'm encountering difficulties connecting to my database.

Additionally, I want to mention that I successfully executed a database migration using the Supabase CLI without any connection issues.

Supabase CLI version: 1.165.0
PgAdmin 4 version: 7.7
macOS version: 14.4.1

[GaryAustin1]

Check the SSL stuff at the end here: https://supabase.com/docs/guides/database/connecting-to-postgres

[bala-goflink]

Enabling SSL and providing the SSL root certificate doesn't make any difference.

[GaryAustin1]

Under windows... I loaded the latest pgAdmin...

And connected immediately and can see everything.
I did not do anything with SSL though.

[bala-goflink]

I installed the newest version of pgAdmin, Version 8.6, and that fixed the problem. Now I can successfully connect.