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 <dp...@pgadmin.org> wrote: > > > On Wed, 22 Jan 2025 at 04:24, Yogesh Mahajan < > yogesh.maha...@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 >> <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 <bjmalone...@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. >>> >>> [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.maha...@enterprisedb.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 <bjmalone...@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 > > -- R. Richard Brockie Real-time bicycle race management - www.ontheday.net
