Thursday, 13 August 2009


The PostGIS experience on mac is a very slick and slippery slope.

First of all the Installers are very Slick

There are a series of nice mac installers that have been bundled up by William Kyngesburye.

And the installers are very good about beeping at you and asking you to install GDAL and PROJ prior to postgis.

And then the slippery ...

The installer don't provide much guidance on where things went ... I am used to having a postgis_template created for me by the windows installers. And all my notes are based on creating new database using that as a safe starting place.

Here were the steps needed to create my own postgis_template:
1) cd /usr/local/pgsql/bin (and then use ./ to get it to pick up the commands)
2) ./createlang plpgsql template_postgis -U postgres
3) ./psql -U postgres -f /usr/local/pgsql/share/lwpostgis.sql template_postgis
4) ./psql -U postgres -f /usr/local/pgsql/share/spatial_ref_sys.sql template_postgis

Other then that pgAdmin looks quite happy.

Wednesday, 12 August 2009

CCIP 1 & 2

It looks like the climate change integration plug fest is set to take off. The hardware has arrived in boxed form; and should be online shortly. To take part join the ccip mailing list where they will sort out login credentials etc.

The size/power of these machines is a bit of a shock to me. I am not used to the wild world of virtualization and was expecting a series of dedicated machines in order to emphasis performance. It will be very interesting for me to see how well virtualization copes with the kind of load produced the different GIS stacks; and conversely if we can make a dent in this amount of processing power.