public inbox for [email protected]help / color / mirror / Atom feed
Unable to use pgadmin4 for any purpose after 3 days of trying 5+ messages / 4 participants [nested] [flat]
* Unable to use pgadmin4 for any purpose after 3 days of trying @ 2025-01-16 03:43 brian malone <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: brian malone @ 2025-01-16 03:43 UTC (permalink / raw) To: [email protected] 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 Attachments: [image/jpeg] Screenshot 2025-01-15 at 7.23.37 PM.jpg (38.9K, 2-Screenshot%202025-01-15%20at%207.23.37%20PM.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unable to use pgadmin4 for any purpose after 3 days of trying @ 2025-01-17 07:39 Yogesh Mahajan <[email protected]> parent: brian malone <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Yogesh Mahajan @ 2025-01-17 07:39 UTC (permalink / raw) To: brian malone <[email protected]>; +Cc: [email protected] 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 <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unable to use pgadmin4 for any purpose after 3 days of trying @ 2025-01-22 04:23 Yogesh Mahajan <[email protected]> parent: Yogesh Mahajan <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Yogesh Mahajan @ 2025-01-22 04:23 UTC (permalink / raw) To: brian malone <[email protected]>; +Cc: pgadmin-support 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-postgr...; link to uninstall the pgadmin application. Thanks, Yogesh Mahajan EnterpriseDB On Fri, Jan 17, 2025 at 11:56 PM brian malone <[email protected]> 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 < > [email protected]> 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 <[email protected]> > 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 > > > Attachments: [image/jpeg] Screenshot 2025-01-15 at 10.32.59 PM.jpg (43.2K, 3-Screenshot%202025-01-15%20at%2010.32.59%20PM.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unable to use pgadmin4 for any purpose after 3 days of trying @ 2025-01-22 09:29 Dave Page <[email protected]> parent: Yogesh Mahajan <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Dave Page @ 2025-01-22 09:29 UTC (permalink / raw) To: Yogesh Mahajan <[email protected]>; +Cc: brian malone <[email protected]>; pgadmin-support On Wed, 22 Jan 2025 at 04:24, Yogesh Mahajan < [email protected]> 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-postgr...; > link to uninstall the pgadmin application. > > Thanks, > Yogesh Mahajan > EnterpriseDB > > > On Fri, Jan 17, 2025 at 11:56 PM brian malone <[email protected]> > 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 < >> [email protected]> 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 <[email protected]> >> 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 Attachments: [image/jpeg] Screenshot 2025-01-15 at 10.32.59 PM.jpg (43.2K, 3-Screenshot%202025-01-15%20at%2010.32.59%20PM.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Unable to use pgadmin4 for any purpose after 3 days of trying @ 2025-01-22 18:26 Richard Brockie <[email protected]> parent: Dave Page <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Richard Brockie @ 2025-01-22 18:26 UTC (permalink / raw) To: pgadmin-support 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 <[email protected]> wrote: > > > On Wed, 22 Jan 2025 at 04:24, Yogesh Mahajan < > [email protected]> 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-postgr...; >> link to uninstall the pgadmin application. >> >> Thanks, >> Yogesh Mahajan >> EnterpriseDB >> >> >> On Fri, Jan 17, 2025 at 11:56 PM brian malone <[email protected]> >> 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 < >>> [email protected]> 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 <[email protected]> >>> 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 Attachments: [image/jpeg] Screenshot 2025-01-15 at 10.32.59 PM.jpg (43.2K, 3-Screenshot%202025-01-15%20at%2010.32.59%20PM.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-01-22 18:26 UTC | newest] Thread overview: 5+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-01-16 03:43 Unable to use pgadmin4 for any purpose after 3 days of trying brian malone <[email protected]> 2025-01-17 07:39 ` Yogesh Mahajan <[email protected]> 2025-01-22 04:23 ` Yogesh Mahajan <[email protected]> 2025-01-22 09:29 ` Dave Page <[email protected]> 2025-01-22 18:26 ` Richard Brockie <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox