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