OS X – Completely Uninstall pgAdmin3

macmacospgadminpgadmin3postgresql

My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the issue. I've tried simply deleting the app and reinstalling that, which doesn't help, but when I do that it also remembers server connections from the previous install, so it must be leaving files somewhere. What do I have to clean up to completely remove pgAdmin3 so I can do a fresh install?

System info: Mac OS X 10.9.1 Mavericks, with pgAdmin3 v1.18.1 installed from the .dmg file downloaded from pgadmin.org

I have already tried

locate .pg*

which finds two files: .pgadmin_histoqueries and .pgpass both in my home directory – removing both didn't change anything. I've also removed pgadmin.log – again no effect.

I've also tried restoring pgAdmin3.app from Time Machine from before the windowing glitch started, but that also doesn't solve anything.

Best Answer

Check your ~/Library/Preferences-Folder. There are the following files you should also remove:

org.postgresql.pgadmin.plist.lockfile
org.postgresql.pgadmin.plist
pgadmin3 Preferences

Remove these also. Especially the last one which contains the server-list.

The org.postgresql.pgadmin.plist does seem to contain some information regarding the windowing system. So perhaps removing that one first might already do the trick.

Related Solutions

Setting up postgresql server connection with pgadmin3 fails with Exception

The mistake I made was that I forgot to uncomment the other lines that set the host, and I didn't restart postgresql so that new changes to that file would take effect. Here are the steps I used:

Find your pg_hba.conf, mine is in /var/lib/pgsql/data/pg_hba.conf

Here are the original incorrect contents of pg_hba.conf, notice the two host lines for IPv4 and IPv6:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
host    all             all             ::1/128                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            ident
#host    replication     postgres        ::1/128                 ident

I had to add these lines at the end of that file

host all all 127.0.0.1/32 md5
#the 32 means only the first 32 bits cannnot change, not the first 24.
#I use 32 because only one address will be accessing this server.

If you don't comment out the other default lines here it won't work:

#host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
#host    all             all             ::1/128                 ident

Then restart postgresql.

[root@rosewill samples ]$ systemctl restart postgresql.service

After restart, try again, and the error is fixed. Then I can login to the sever with pgadmin3.

Mac – Completely Uninstall Apple Remote Desktop macOS Sierra 10.12.4

macOS 10.12.4 is only a public beta at this time.

Congratulations, your beta testing has successfully found a bug. Please report it to Apple via bugreport.apple.com.

I would guess there's an ARD Admin update due to coincide with the real release of macOS 10.12.4, but perhaps there's no public beta for ARD Admin at this time. There appears to be a private beta for people in the developer program. Does that include you? If so, go get the ARD admin beta.

Otherwise your best bet is probably to downgrade to macOS 10.12.3, the last real public production release of macOS Sierra. The ARD agent in that release probably matches with the ARD admin that's publicly available.

Best Answer

Related Solutions

Setting up postgresql server connection with pgadmin3 fails with Exception

Mac – Completely Uninstall Apple Remote Desktop macOS Sierra 10.12.4

Related Question