Hi,
In order to try backup/restore of production environment, I want to install
PostgreSQL 9.3 / Postgis 2.1 on a fresh Debian Jessie server.
To do that, I add the postgresql repository:
echo "deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main" >
/etc/apt/sources.list.d/pgdg.list
Then
Hi all,
I am upgrading PostgreSQL and PostGIS from 9.3/2.1 to 9.5/2.3.
I perform the backup on the old server (9.3/2.1) like this using pg_dump.
Then, on the new server (9.5/2.3), I restore the backup using pg_restore.
Everything is correctly restored, except just one raster table, a DEM, whic
Hi all,
I try to calculate the slope at precise points by intersection between a
vector layer of points and a raster DEM (both with the same SRID).
I would like to get the result in percent, giving the slope on each point of
my vector layer.
Here is the query I use :
SELECT p.id, p.x, p.y, ST_Va
I tried an install under WinXP.
Everything works good and projection results are OK.
So, the problem, on my Ubuntu server, seems to come from my build from
sources.
The postgis_full_version() gives :
POSTGIS="2.0.2 r10789" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March
2012" GDAL="GDAL 1.9.1, r
