Hi. 

I was eventually able to find a workaround. 

I was using brew to install postgreSQL@14 on a Mac. 

I could get a version of pgAdmin4 to work when using the standalone installer (https://www.pgadmin.org/download/pgadmin-4-macos/). I ended up installing 8.13. I downloaded the software as a .dmg file. 

The problem seemed to be that postgres was the default superuser for pgAdmin, but I (as my username on my machine) was the default superuser with brew. 

I eventually created a new Server Group, since the default one would never work. That new Server Group had me (as my username, not postgres) as the superuser and things seemed to work fine. I still seem to lack the permissions to delete the original Server Group, now renamed to Servers_DEFUNCT, though. 

I think there are differences in how brew installs software and the alternative process via .dmg files. 

However, I still have a version of 8.14 on my system. That version will not run, though. I likely trashed an aspect of the software during one of the many cycles of uninstalling and re-installing. 

That said, I would like to remove version 8.14 so it doesn’t compete with the working version. 

If I use Spotlight to check for ‘pgAdmin4’, there is a version that appears as

1) pgAdmin 4 — Applications (That one works)

and 

2) pgAdmin 4 — PostgreSQL 14 (That one produces the error message above). 

How would I install the software properly to avoid these competing versions? 

Can you explain what happened, and how I can have a clean, singular installation with a single superuser that matches across psql from the command line and within pgAdmin4? 

Thanks, 

Brian  

On Jan 16, 2025, at 11:39 PM, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hi,

What is your PostgreSQL installer version? You can download seperate installer for pgadmin from here.

Thanks,

Yogesh Mahajan

EnterpriseDB

On Fri, Jan 17, 2025 at 11:42 AM brian malone <bjmalone724@gmail.com> wrote:

Hi.

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.

Thanks,

Brian