Bruce,
a couple of things :
$PATH won't help - the only program you are using is psql, and that is running.
FWIW, I would put /usr/local/pgsql-9/0/bin into your path so you don't have to
type the full command every time.
AddGeometryColumn is a PostGIS function - if you can run
psql nyc
and
Thanks to Ben Madin for advice. I removed the apostrophes from the SRID in
nyc_buildings.sql (using TextEdit) and re-ran the command
/usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc
Unfortunately it produced the same result:
BEGIN
psql:/Users/bacmac/nyc_buildings.sql:3: NOT
Bruce,
On 15/08/2011, at 6:28 PM, b...@brucecallander.com wrote:
> $ /usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc
>
> The Geoserver instructions are not explicit about where to put the
> nyc_buildings.sql file so I have left it in my own user directory 'bacmac'.
It doe
Hi Bruce,
I'm pretty new to GIS and PostGIS, but I'll try to offer an
idea. It appears that you might not have the postgis code
loaded. I'm going to guess that Nicholas' suggestion
involved setting up the template_postgis database so that
you might make postgis enabled databases without manual
I am following the Geoserver Getting Started documentation in order to create
an example PostGIS table.
I am working on a MacBook running Snow Leopard v10.6.8
Thanks to previous advice from the forum (Nicolas Ribot) I was able to create
the sample database 'nyc' based on the template 'template_