No matter what I do, I cannot connect to any databases using pgadmin4.
I am using a Mac (Ventura), and downloaded postgreSQL@14 via brew.
By default, I am a superuser with psql, and that works normally.
However, with pgadmin4, I am ‘postgres’ and cannot access any databases, due to a connection error.
I have tried uninstalling and reinstalling multiple times. At this point, I cannot even run the software because of this issue.
This is the most frustrating experience I have ever had with software installation by a fair margin, but I really need to learn SQL and would like to use this tool.
Is there any way to completely uninstall it, and start again, and get the permissions resolved? I have spent days asking chatbots to resolve this issue but their help was insufficient. Again, psql works fine, but I want to be able to follow along with a course taught with the actual tool.
