Re: [postgis-users] ST_ConcaveHull performance issue

2019-08-02 Thread Trevor Wiens
Thanks to both of you. I tried running with perf now and found most of the time was spent in libstdc++ doing dynamic casting and related functions for 80% of CPU time. Within geos itself, the top time spent is in the SimplePoitnInAreaLocator and STRIntersectsOp functions. I don't know how geos wor

Re: [postgis-users] ST_ConcaveHull performance issue

2019-08-02 Thread Regina Obe
There is was an issue with ST_Union as applied to invalid polygons introduced in 3.7.1 and 3.6.2 which would make ST_Union run indefinitely. It appears to still be an open bug. This smells like that issue. https://trac.osgeo.org/geos/ticket/867 https://lists.osgeo.org/pipermail/postgis-

Re: [postgis-users] ST_ConcaveHull performance issue

2019-08-02 Thread Trevor Wiens
Thanks for your reply. It was mix of points, lines and polygons, but when I broke it down it was the lines causing the problem. I tried commenting out the line in the ST_ConcaveHull function you suggested but that doesn't make a difference. I suspect there is some underlying library that has chang

Re: [postgis-users] PostGIS setup on Postgres-XL

2019-08-02 Thread Imre Samu
>Tried but not working - And what was the error message? What is not working? - And have you tried the manual install ? - see suggestion: "Install PostGIS manually into PostgreSQL-XL" - So you are on ubuntu - on not on centos/debian/ ... for manual install: - You can find the compatibility matri

Re: [postgis-users] PostGIS setup on Postgres-XL

2019-08-02 Thread Pradeep Kanth G
Tried but not working Regards Pradeep Kanth From: postgis-users On Behalf Of Imre Samu Sent: Friday, August 2, 2019 5:10 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS setup on Postgres-XL > We already HA setup with Postgres-Xl 9.5, now trying to install PostGI

Re: [postgis-users] PostGIS setup on Postgres-XL

2019-08-02 Thread Imre Samu
> We already HA setup with Postgres-Xl 9.5, now trying to install PostGIS > Kindly let us know how to install on Postgres-XL database. Have you tried this? ( on ubuntu ) https://stackoverflow.com/questions/51677417/postgis-extension-on-postgres-xl/51690778 best, Imre Pradeep Kanth G ezt ír

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Hi, I am using Centos 7 Regards Pradeep Kanth From: postgis-users On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Friday, August 2, 2019 4:30 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Error on PostGIS Hi, To cross check your actions please have a look at

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
Hi, To cross check your actions please have a look at this definitely working recipe: https://github.com/postgis/postgis-build-env/blob/master/Dockerfile#L49 You may also want to utilize prebuilt distribution provided packages, say, from Ubuntu 19.04 or Debian Sid. On Fri, Aug 2, 2019 at 1:53 PM

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Hi, I have downloaded but I am not able to install. Followed below steps . Downloaded the file. [root@node1 SFCGAL-1.3.7]# cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local -CMake Error: The source directory "/root/SFCGAL-1.3.7/build" does not appear to contain CMakeLists.txt. Specify --

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
Hi, Please install SFCGAL and its dependencies, as suggested by the error. Current version of libsfcgal is 1.3.7. On Fri, Aug 2, 2019 at 1:16 PM Pradeep Kanth G wrote: > Thanks, now it is in progress. > > > > Getting the below error > > In file included from lwgeom_sfcgal.c:26:0: > > lwgeom_sfc

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Thanks, now it is in progress. Getting the below error In file included from lwgeom_sfcgal.c:26:0: lwgeom_sfcgal.h:28:34: fatal error: SFCGAL/capi/sfcgal_c.h: No such file or directory #include ^ compilation terminated. make[1]: *** [lwgeom_sfcgal.lo]

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
This file is shipped as part of Proj library. If you are installing it via your package management system, make sure you're installing libproj-dev (in Debian-like) or proj-devel (in RPM-like). On Fri, Aug 2, 2019 at 12:59 PM Pradeep Kanth G wrote: > Hi, > > > > I have tried but not getting this

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Hi, I have tried but not getting this file. Kindly let us know, where we have to get? Regards Pradeep Kanth From: postgis-users On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Friday, August 2, 2019 3:28 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Error on PostGI

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
Hi, Can you check that development headers of proj are actually available, looking for proj_api.h in your file system? On Fri, Aug 2, 2019 at 12:55 PM Pradeep Kanth G wrote: > Hi, > > > > Installed latest(PostGIS2.5.2 & GEOS 3.7.2) version, but getting the same > error. > > > > configure: error

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Hi, Installed latest(PostGIS2.5.2 & GEOS 3.7.2) version, but getting the same error. configure: error: could not find proj_api.h - you may need to specify the directory of a PROJ.4 installation using --with-projdir Regards Pradeep Kanth From: postgis-users On Behalf Of Darafei "

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
Hello, PostGIS 2.2 is End of Life. Current release is 2.5.2. GEOS 3.3 is End of Life. Current release is 3.7.2. Please consult this matrix when choosing the best versions combinations: https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS On Fri, Aug 2, 2019 at 12:33 PM Pradeep Kanth

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Hi, Trying on below versions.. postgis-2.2.1 geos-3.3.5 gdal-1.9.1 Installed proj-4.8.0 , proj-4.9.1 and proj-5.2.0 but no luck. Regards Pradeep Kanth From: postgis-users On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Friday, August 2, 2019 2:40 PM To: PostGIS Users Discuss

Re: [postgis-users] Error on PostGIS

2019-08-02 Thread Komяpa
Hello, what are the versions of proj and postgis that you are using? On Fri, Aug 2, 2019 at 12:03 PM Pradeep Kanth G wrote: > Dear All, > > While installing the PostGIS, getting the below error. > > ./configure --with-pgconfig=/home/postgres/pgxl/bin/pg_config > > Error: > > configure: error: c

[postgis-users] Error on PostGIS

2019-08-02 Thread Pradeep Kanth G
Dear All, While installing the PostGIS, getting the below error. ./configure --with-pgconfig=/home/postgres/pgxl/bin/pg_config Error: configure: error: could not find proj_api.h - you may need to specify the directory of a PROJ.4 installation using --with-projdir make: *** [GNUmakefile] Error