[postgis-users] help : postgis on a mac os x

[Burgholzer,Robert]

Youssef,

Ben mentioned the "create lang" step.  I suspect this is what you are missing.  The postgis functions are written in the language pl/Pgsql, which is an iptional add-on for any postgresql database.  In order to add this language, you must do the following:

 

sudo su - postgres -c '/usr/local/pgsql/bin/createlang plpgsql [dbname]'

 

Robert W. Burgholzer

Surface Water Modeler

Office of Water Supply and Planning

Virginia Department of Environmental Quality

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

  _____  

From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Youssef BEGHI
Sent: Thursday, February 26, 2009 11:04 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] help : postgis on a mac os x

 

Hello everyone ,
 
I'm not quite familiar with the GIS. I try to install postGIS in a mac os x (leopard) but it doesn't work when I performe the command :

sudo su - postgres -c '/usr/local/pgsql/bin/psql -d [dbname] -f /usr/local/pgsql/share/lwpostgis.sql'

with my dbname instead of [dbname]
I recieve many error lines like these

psql:/usr/local/pgsql/share/lwpostgis.sql:6500: ERROR: current transaction is aborted, commands ignored until end of

please help,


-- 
Youssef BEGHI
-----------------------------------------------------------------
Sois heureux d'aujourd'hui ! Ne parle pas d'hier.
[Omar Khayyâm]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090304/06e45ffe/attachment.html>