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

Adding to Dave's note: I've used brew to manage both postgres (multiple
parallel versions) and pgAdmin4 installations for several years. The
default user assumption takes a moment to understand, but apart from that
installation has been straightforward. The only important thing to remember
is to stop postgres before upgrading to a new version via brew.

https://stackoverflow.com/questions/23769579/default-password-for-my-user-in-postgresql

On Wed, Jan 22, 2025 at 1:29 AM Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> 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
>
>

--
R.

Richard Brockie

Real-time bicycle race management - www.ontheday.net