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

Burgholzer,Robert rwburgholzer at deq.virginia.gov
Wed Mar 4 06:18:49 PST 2009


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


Open Source Modeling Tools:



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>

More information about the postgis-users mailing list