On Wed, 22 Jan 2025 at 04:24, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hi,

pgadmin4 is not shipped with brew installers. 

As a point of clarification, Brew does include pgAdmin in their catalog. I have no idea how they install it, and whether we'd consider it supported or not though.

 

Have you ever used the EDB PostgreSQL installer to install postgres? If yes, Please refer this link to uninstall the pgadmin application.

Thanks,

Yogesh Mahajan

EnterpriseDB

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

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

--

Dave Page

pgAdmin: https://www.pgadmin.org

PostgreSQL: https://www.postgresql.org

pgEdge: https://www.pgedge.com