Re: Unable to use pgadmin4 for any purpose after 3 days of trying

Hi,

pgadmin4 is not shipped with brew installers.
Have you ever used the EDB PostgreSQL installer to install postgres? If
yes, Please refer this
<https://www.enterprisedb.com/docs/supported-open-source/postgresql/uninstalling/#uninstalling-postgresql-on-mac>
link to uninstall the pgadmin application.

Thanks,
Yogesh Mahajan
EnterpriseDB

On Fri, Jan 17, 2025 at 11:56 PM brian malone <bjmalone724(at)gmail(dot)com> wrote:

> Hi.
>
> I was eventually able to find a workaround.
>
> I was using brew to install postgreSQL(at)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.
>
> [image: Screenshot 2025-01-15 at 10.32.59 PM.jpg]
>
> 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(dot)mahajan(at)enterprisedb(dot)com> wrote:
>
> Hi,
>
> What is your PostgreSQL installer version? You can download seperate
> installer for pgadmin from here
> <https://www.pgadmin.org/download/pgadmin-4-macos/>.
>
> Thanks,
> Yogesh Mahajan
> EnterpriseDB
>
>
> On Fri, Jan 17, 2025 at 11:42 AM brian malone <bjmalone724(at)gmail(dot)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(at)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
>
>
>