I uninstalled everything (again) manually since the binaries I last used (from http://postgresapp.com/) did not have any uninstaller.
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 ? 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