On Aug 13, 2012, at 6:43 PM, António Rodrigues wrote: > I uninstalled everything (again) manually since the binaries I last used > (from http://postgresapp.com/) did not have any uninstaller. > OK, you used a different Postgres in the past, and uninstalled that (I've never heard of postgres.app, but it looks like a simple uninstall). It sounded like you tried uninstalling my Postgres.
> I installed again the binaries from kyngchaos. Postgis is in > /usr/local/pgsql-9.1/share/contrib/postgis-2.0. > > The question is: in order to create a Postgis extension inside my database, > when in pgadmin I create a new extension, there is no Postgis option. Can I > just copy what is in the Postgis-2.0 folder into > /usr/local/pgsql-9.1/share/extension ? No, you can't copy share/contrib/postgis-2.0 files to share/extensions. It's very odd that you have no PostGIS extension files. Try reinstalling just PostGIS, and you don't need to uninstall anything. > Thanks, > Pedro > > On Mon, Aug 13, 2012 at 11:29 PM, William Kyngesburye <wokl...@kyngchaos.com> > wrote: > How did you remove Postgres? > > Were there any errors in the installation of PostGIS? > > On Aug 13, 2012, at 9:57 AM, António Rodrigues wrote: > > > Thanks for the reply. > > > > I completely removed postgresql. Re-installed from PostgreSQL-9.1.4-1.dmg > > and PostGIS-2.0.1-1.dmg. Now there are no traces of postgis in > > /usr/local/pgsql-9.1. Is this normal? > > > > One other thing, from what I read and sticking for now to the advice of > > enabling postgis using extensions, shouldn't the postgis sql stuff be here > > -> /usr/local/pgsql-9.1/share/extension, so that in pgadmin, choosing new, > > postgis would show up as an option? > > > > Sorry if I'm missing something obvious. > > Thanks, > > Pedro > > > > On Sun, Aug 12, 2012 at 4:51 AM, William Kyngesburye > > <wokl...@kyngchaos.com> wrote: > > On Aug 11, 2012, at 8:35 PM, António Rodrigues wrote: > > > > > Hi list, > > > > > > I'm having problems enabling postgis on a mac running Mountain Lion. Most > > > likely this is due to my absolute lack of experience with postgresql, but > > > I've read the documentation, searched the web and so far, no luck. > > > > > > This is what I've done > > > > > > Installed GDAL_Complete-1.9.dmg, PostgreSQL-9.1.4-1.dmg and > > > PostGIS-2.0.1-1.dmg from kyngchaos (in this order) > > > > > > During installation, I was not prompted for a postgres password, hence I > > > had problems when connecting as user (role) postgres. > > > > This is normal - no password is set for the postgres role on installation. > > Local connections to postgres are all allowed without a password, and no > > external connections are allowed at all, in the default configuration > > (pg_hba.conf), so it should work, but the readme suggests setting a > > password (especially if you install it on a shared computer). > > > > > In pgadmin I created a new role as superuser. > > > > > > ---------- > > > From PostGIS documentation, I tried (in the psql console plugin… > > > > > > (p.14 in PostGIS 2.0.0 Manual) > > > > > > createdb db1 > > > createlang plpgsql db1 > > > psql -d db1 -f postgis.sql > > > psql -d db1 -f spatial_ref_sys.sql > > > psql -d db1 -f postgis_comments.sql > > > psql -d db1 -f rtpostgis.sql > > > psql -d db1 -f raster_comments.sql > > > psql -d db1 -f topology/topology.sql > > > psql -d db1 -f topology/topology_comments.sql > > > psql -d db1 -f legacy.sql > > > > > > Nothing new: no postgis functions... > > > > > > Then Using the psql console plugin I typed: > > > (p. 15PostGIS 2.0.0 Manual) > > > psql -d db -c "CREATE EXTENSION postgis;" > > > psql -d db -c "CREATE EXTENSION postgis_topology;" > > > > > > Again no good. > > > > The problem may be that without any user flag, psql uses your system login > > name to connect to postgres. If you don't setup your login name as a > > postgres role, you won't connect. You need to add to your psql connection: > > > > -U postgres > > > > or other role with full permissions on the DB (I don't think you need > > superuser perms, only the superfluous createlang step in the old method > > did). > > > > note: stick with the extension method - easier to install and upgrade. > > > > > Then I pasted the code in from postgis.sql (from \usr\…contrib\postgis2.0 > > > directly in a sql window in pgadmin… > > > > > > I got the error message: "ERROR: could not access file > > > "$libdir/postgis-2.0": No such file or directory" > > > ---------- > > > > > > I am aware this is a newby kind of problem, and I apologize for that, but > > > some help would be really really great. > > > Thanks, > > > Pedro > > > _______________________________________________ > > > postgis-users mailing list > > > postgis-users@postgis.refractions.net > > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > ----- > > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> > > http://www.kyngchaos.com/ > > > > Theory of the Universe > > > > There is a theory which states that if ever anyone discovers exactly what > > the universe is for and why it is here, it will instantly disappear and be > > replaced by something even more bizarrely inexplicable. There is another > > theory which states that this has already happened. > > > > -Hitchhiker's Guide to the Galaxy 2nd season intro > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ----- > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> > http://www.kyngchaos.com/ > > "History is an illusion caused by the passage of time, and time is an > illusion caused by the passage of history." > > - Hitchhiker's Guide to the Galaxy > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ----- William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> http://www.kyngchaos.com/ All generalizations are dangerous, even this one. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
