I have multiple installations of PostgreSQL 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:
/usr/local/pgsql/bin/postgres
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.