Re: [postgis-users] Running postgis from apache user

2012-02-09 Thread Martin Spott
Roberto Marzocchi wrote: Within a pywps script I want to access to postgresql database using Grass gis and I receive an error message: *ERROR 1: PostgreSQL ddriver doesn't currently support database creation.* I have already verified the correctness of the command running it from normal unix

Re: [postgis-users] BYTE_ORDER in SVN trunk on Solaris/i386

2011-12-27 Thread Martin Spott
Thanks a lot for the recent fixes, I've just migrated my PostGIS DB to SVN trunk (the backend to scenemodels./mapserver.flightgear.org). Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are !

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

2011-12-27 Thread Martin Spott
THX1138 wrote: Thanks for your help on this, I really appreciate it! When building gdal 1.8 or 1.9 what dependencies/drivers/configuration options are needed for postgis2.0 to function correctly if any? Very few, but if you're building GDAL with Python bindings, you'll get PostGIS raster for

Re: [postgis-users] Installing a fully functional PostGIS 2.0 on

2011-12-27 Thread Martin Spott
THX1138 wrote: So I add these bindings after configuring/building/installing gdal but they must be installed before configuring/building/installing postgis? In order to build GDAL for PostGIS you should have these installed (libraries and header files): - Proj.4 - GEOS - Python Follow

Re: [postgis-users] BYTE_ORDER in SVN trunk on Solaris/i386

2011-12-21 Thread Martin Spott
Sandro Santilli wrote: We used to have our owh byte order detector as well. May still be there (symbol getMachineEndian). Should do fine. Oh, I just found out there _is_ a ticket at: http://trac.osgeo.org/postgis/ticket/1172 which I didn't notice at first. Cheers, Martin. --

Re: [postgis-users] BYTE_ORDER in SVN trunk on Solaris/i386

2011-12-19 Thread Martin Spott
Paul Ramsey wrote: On Fri, Dec 16, 2011 at 8:58 AM, Martin Spott martin.sp...@mgras.net wrote: Martin Spott wrote: at least according to my experience, liblwgeom/lwout_wkb.c (and probably others as well, but I didn't check) is missing a declaration of BYTE_ORDER on Solaris platforms

[postgis-users] BYTE_ORDER in SVN trunk on Solaris/i386

2011-12-16 Thread Martin Spott
Hi, at least according to my experience, liblwgeom/lwout_wkb.c (and probably others as well, but I didn't check) is missing a declaration of BYTE_ORDER on Solaris platforms. Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are !

Re: [postgis-users] BYTE_ORDER in SVN trunk on Solaris/i386

2011-12-16 Thread Martin Spott
Martin Spott wrote: at least according to my experience, liblwgeom/lwout_wkb.c (and probably others as well, but I didn't check) is missing a declaration of BYTE_ORDER on Solaris platforms. with GCC, Martin. -- Unix _IS_ user friendly - it's just selective about who its

Re: [postgis-users] importing planet_110928.osm, fail after 5 days

2011-10-09 Thread Martin Spott
Torsten Mohr wrote: i just set up PostGis and imported OSM data. it took 5 days and failed at the end, out of memory. Does out of memory mean RAM or can it also mean disk space? If you're using osm2pgsql, it usually runs out of RAM. Check the -s option ah, I see, you already did.

Re: [postgis-users] compile on solaris 11 sparc

2011-09-15 Thread Martin Spott
Mark Cave-Ayland wrote: [...] I'm not sure what the correct command line should be to invoke the pre-processor in Sun's compiler is though. cc -E ;-) Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are !

Re: [postgis-users] compile on solaris 11 sparc

2011-09-02 Thread Martin Spott
Paul Ramsey wrote: My guess is that your gcc is generating a 32-bit object and then failing to link it to the 64-bit library. As an alternative, you might try building 64-bit binaries of everything, at least this is what I'm doing on Solaris and the result is working properly. Just set an

Re: [postgis-users] compile on solaris 11 sparc

2011-09-02 Thread Martin Spott
Doug McComber wrote: On 09/ 2/11 04:59 AM, Martin Spott wrote: CC=gcc -m64 CXX=g++ -m64 CPP=gcc -m64 -E [...] CPP=gcc [...] /opt/studio11/SUNWspro/bin/cc -Xa -E -traditional-cpp postgis.sql.in.c | grep -v '^#' postgis.sql.in /bin/sh: line 1: /opt/studio11/SUNWspro/bin/cc: not found

Re: [postgis-users] Reg PostGIS Shapefile Loader

2011-08-08 Thread Martin Spott
Harshad Shrikhande wrote: No record was inserted into the database as a psql exception occurred saying 'Invalid value for a double type field'. Sounds to me like a column in the table was defined as a double and you tried inserting values of an incompatible type (maybe string or the like).

Re: [postgis-users] PostGIS 2.0 installation error

2011-07-04 Thread Martin Spott
Denis Rykov wrote: Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server? No ;-) Recent PostGIS SVN works nicely here, at least on a test-scenario I'm running with PostgreSQL 9.1beta2, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are !

[postgis-users] --with-gdalconfig; Was: How do you use PostGIS Raster?

2011-06-07 Thread Martin Spott
Pierre Racine wrote: I'm preparing a presentation and I need some use cases for PostGIS Raster. I would be grateful if people already using the raster side of PostGIS would describe what they already do it. Inspired by this call I started aiming at using PostGIS Raster for my/our project.

Re: [postgis-users] --with-gdalconfig;

2011-06-07 Thread Martin Spott
Hi Jorge, Jorge Arévalo wrote: You need to specify --with-raster too. I already did that - actually that's the reason why 'configure' stops after the GDAL test fails ;-) This is the complete 'configure' command line: ./configure --prefix=/opt/PostgreSQL \

Re: [postgis-users] --with-gdalconfig;

2011-06-07 Thread Martin Spott
Martin Spott wrote: but the check checking for GDAL = 1.6.0... fails with not found. Adding the directory /opt/PostgreSQL/bin to the $PATH helps. BTW, on this custom setup with GDAL installed in '/opt/PostgreSQL/', additionally to adding /opt/PostgreSQL/bin to $PATH, it's required to set

Re: [postgis-users] --with-gdalconfig;

2011-06-07 Thread Martin Spott
Hi Jorge, Jorge Arévalo wrote: On Tue, Jun 7, 2011 at 5:49 PM, Martin Spott martin.sp...@mgras.net wrote: Martin Spott wrote: BTW, on this custom setup with GDAL installed in '/opt/PostgreSQL/', additionally to adding /opt/PostgreSQL/bin to $PATH, it's required to set $LD_LIBRARY_PATH

Re: [postgis-users] multiline with with to polygon

2011-06-03 Thread Martin Spott
Jaime Lop wrote: Is there an easy way to convert multi lines with a width to polygons? For example, I have a corridor defined as 100 kms around a given line. PostGIS doesn't support this feature, as far as I can tell from my limited insight, but if it would, I'd be one of its users ;-)

Re: [postgis-users] Building on Solaris 10 x86

2011-03-26 Thread Martin Spott
Andreas Luka wrote: Could you support us with some more information 1. Build Platform Sparc or x86 Over the past years I've been running PostGIS on Sparc as well as on x86 - the database behind 'mapserver.flightgear.org' is now running on Solaris10/AMD64 and has been running on Solaris10/SPARC

Re: [postgis-users] Building on Solaris 10 x86

2011-03-24 Thread Martin Spott
Vinicius Carvalho wrote: Thanks Jorge, after creating the symlink it passes that part but it seems that my gcc is not what postgis expects :( I'm not sure which symlink you set, but from my perspective this looks very much like an inconsistent compiler setup. There are strong signs that you're

Re: [postgis-users] Signal 11

2010-12-21 Thread Martin Spott
Hi Nicklas, Nicklas Avén wrote: I get this error, but no crash. Thanks for checking. Wether it crashes the DB server or not might probably related to the respective platform or setup - I guess ;-) Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its

[postgis-users] Signal 11

2010-12-20 Thread Martin Spott
Hi folks, I'm having a case where a certain statement reproducibly crashes the server process. The system is running Solaris10 on Intel Xeons, all specific software is compiled into 64-bit binaries using GCC-3.4.3: - PROJ.4 4.7.0 - GEOS 3.2.2 - libiconv 1.13.1 - PostgreSQL 9.0.1 - PostGIS

Re: [postgis-users] How To build postGIS on debian with pbuilder?

2010-05-21 Thread Martin Spott
Stephen Woodbridge wrote: Does anyone know how to build postGIS using pbuilder on Debian lenny. I have been about to build geos-3.2.0 and proj-4.6.1 Get the usual suspects like GEOS and PROJ.4 from the fine http://debian.gfoss.it/ and feel free to check if the packages at this location are

Re: [postgis-users] Best way to

2007-12-08 Thread Martin Spott
[EMAIL PROTECTED] wrote: We are developing a solution using geoserver with postgis postresql server. Out database is going to be huge [...] What means 'huge' ? The site http://mapserver.flightgear.org/ stores approx 80 GByte of data online in more than 200 tables (plus 50 GByte stuff that's

Re: [postgis-users] Tiger Files on Windows PostGIS

2007-09-29 Thread Martin Spott
Obe, Regina wrote: It is my understanding that the 2007 and up Tiger files are going to be in ESRI shape. I've read the same, yet I don't know of any release date. I have the complete TIGER 2006se set online at: http://mapserver.flightgear.org/ and I'd offer to produce a set of shapefiles