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
