Phantom half-install: How can I remove it completely? - Mailing list pgsql-admin

From Jonathan Hayward
Subject Phantom half-install: How can I remove it completely?
Date
Msg-id CAE6_B5TaZ_1WSnHGwYO428_GqQG=Dx2rv5T7eLQoOgc-Jh0DaQ@mail.gmail.com
Whole thread Raw
Responses Re: Phantom half-install: How can I remove it completely?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains there after I deleted the Mac GUI installer version from /Applications and /Library. Part of the spooky behavior included being unable after repeated poking and prodding to get a particular user to authenticate with its behavior--but this makes sense if I had two parallel Postgres databases, one for which I was (successfully) setting the user with a particular password, and one which did not have this database set. Now that that version is uninstalled, I have a number of Postgres binaries that crash or give errors if I try to use them:

$ psql
dyld: Library not loaded: /usr/lib/libpq.5.dylib Referenced from: /usr/bin/psql Reason: image not found
Trace/BPT trap: 5
$

I have not used MacPorts, Fink, or other Unix installers other than Homebrew in the life of this Mac. Homebrew disclaims ownership of a Postgres installation:

# ls /usr/local/Cellar | grep -i postgres
# 

So however installed, I have a broken Postgres installation that I would like to wipe completely.

How can I completely wipe Postgres from my system so I can install it with the installer and have one Postgres installation, instead of a spooky one and a half installations?


--
Christos Jonathan Hayward
Christos Jonathan Hayward, an Orthodox Christian author.

Amazon • Author Bio • Email • Facebook • Fan Page • Google Plus • LinkedIn • Professional • Twitter • Web • What's New?

If you read just one of my books, you'll want The Best of Jonathan's Corner.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: my query is so slow,It costs 944,319.072 ms,Can someone Help!!
Next
From: Tom Lane
Date:
Subject: Re: Phantom half-install: How can I remove it completely?