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

On Wed, 22 Jan 2025 at 04:24, Yogesh Mahajan <
yogesh(dot)mahajan(at)enterprisedb(dot)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
> <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
>>
>>
>>

--
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
pgEdge: https://www.pgedge.com