Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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

http://www.kyngchaos.com/software/postgres

It includes instructions for Postgis installation.

This is another website with more options:

http://trac.osgeo.org/postgis/wiki/UsersWikiPackages

share|improve this answer
    
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 '12 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 '12 at 16:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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