Struggling with enabling a PostGIS database on Mac

Question

I have installed PostGIS on the mac using the binaries available on http://www.kyngchaos.com/software:postgres

Postgres v 9.1.3

PostGIS v 2.0

After that I want to enable postgis for my database. I tried using CREATE EXTENSION query. But it error'ed out saying that the extension is not available. I then tried

sudo -u postgres psql -d [your database] -f /usr/local/pgsql/share/contrib/postgis-2.0/postgis.sql
Password: 
SET
BEGIN
psql:/usr/local/pgsql/share/contrib/postgis-2.0/postgis.sql:69: ERROR:  could not access file "$libdir/postgis-2.0": No such file or directory

How can i make $libdir expand into the path which i found by executing

$ pg_config --pkglibdir
/usr/lib/postgresql

The /usr/lib/postgresql does NOT contain postgis-2.0.

Digging around for a few more hours I found a hacky solution:

export PATH=/usr/local/pgsql/bin:$PATH

This makes the pg_config magically change to:

$ pg_config --pkglibdir
/usr/local/pgsql-9.1/lib

And then I hardcode that path into the postgis.sql file. But I want to know why $libdir doesnt resolve automatically.

Answer 1

I get the same error after updating postgres with a working postgis install. Although this does not answer the original question, I'm adding this answer since the error is the same. The postgis .so files will not be in the postgres package directory (pg_config --pkglibdir) after a new postgres install. These files need to be there:

$ ls -l /usr/local/Cellar/postgresql/9.2.3/lib | grep postgis
-rwxr-xr-x  1 tee  wheel   585416 Feb 24 14:39 postgis-2.0.so
-rwxr-xr-x  1 tee  wheel   434752 Feb 24 14:39 rtpostgis-2.0.so

The simplest solution is to reinstall postgis after a postgres update:

brew uninstall postgis
brew install postgis

Answer 2

When you run psql, you're probably running the binary that's installed on OSX by default in /usr/bin. Run 'which psql' to be sure. Altering your $PATH like that changes which pg_config you're using. That's not a hacky solution to change your $PATH like that, it's perfectly OK. I recommend installing Postgres and PostGIS using homebrew though.