I have multiple installations of postgres on my machine, and would like to narrow down to a single installation (macports flavor).
I believe that OSX comes shipped with some sort of package, but I am not aware of where it gets put, or how to troubleshoot where to find it and uninstall.
This has been a huge headache for me, so any help would be appreciated. I'm running 10.7.5.
which postgres yields:
And in my bash profile, I have:
PG_SQL=/usr/local/pgsql/lib:/usr/local/pgsql/bin export PG_SQL
port installed yields:
postgresql92 @9.2.2_0 (active)
postgresql_select @0.1_0 (active)
'sh-3.2# find . -iname PG_VERSION' yields:
./postgres/database/base/1/PG_VERSION ./postgres/database/base/12265/PG_VERSION ./postgres/database/base/12270/PG_VERSION ./postgres/database/base/16384/PG_VERSION ./postgres/database/PG_VERSION
that is relative to /Users, btw.