I am running PostgreSQL 9.0 on Mac OS 10.5. I've installed postgis-pg90-1.5.3-1-osx through "Stack Builder" but still don't see postgis in my list of databases when I open PgAdmin. When I open my Qgis 1.7, I can connect to my postgres database and display all tables with no spatial geometry. However, when I try to query a non-spatial table, I get the following message "Your database has no working PostGIS support". I appreciate your ideas to get postgis to integrate into postgresql. Thanks!

Thanks for your ideas! Unfortunately, the first link (http://www.kyngchaos.com/software/postgres) is limited to "...Lion and Snow Leopard, 64bit only." I'm using Leopard (Mac OS 10.5). The second link (http://trac.osgeo.org/postgis/wiki/UsersWikiPackages) provides two options. Both of these (http://yum.postgresql.org/repopackages.php) & (http://www.postgresonline.com/journal/archives/204-postgis15-install-yum.html) point to Linux installations. So, I'm still stuck. I've downloaded PostGIS 1.5 using Application Stack Builder 3.0.0 from PostgreSQL 9.0. It installs, but does not run. I appreciate any other suggestions.

1 Answer 1


I used this website to install the same version of PG you are using on my Mac.


It includes instructions for Postgis installation.

This is another website with more options:


  • Are you able to see which database exist in your current PG installation? You could try to use the psql shell in your command line or pgAdmin and see if you have a template_postgis database. That could help you determine if postgis was installed correctly but QGIS cannot find it. Also I think QGIS will prefer to read tables from databases based on template_postgis that have a geometry_columns table or view. Tabular (non-spatial) databases don't have one. Hope that helps a little.
    – LEC
    Oct 19, 2012 at 16:00
  • I get the same error you get when I try to connect to a non-spatial database from QGIS. See if you can create a database based on template_postgis (i.e. using template_postgis as a template), add a couple of tables there (spatial and non-spatial) and see if you can connect.
    – LEC
    Oct 19, 2012 at 16:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.