[postgis-devel] [raster] Testing out-db and regular blocking

[Mateusz Loskot]

On 26 February 2013 14:47, Bborie Park <dustymugs at gmail.com> wrote:
>
> Which version of PostGIS are you running?  The constraint should be
> the same regardless of where the data is store.
Hi Bborie,

Apology for rookie's error, I should have included the version.
As the Gist description says, I run build based on SVN trunk r11115.
I also use GEOS and GDAL from their SVN trunks.

> But, does the account running the postgres server have
> access to the out-db raster?

Yes, I think so:

postgres:~$ ps -ef|grep '9.1/bin/postgres'
postgres  1012     1  0 10:09 ?        00:00:00
/usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main
-c config_file=/etc/postgresql/9.1/main/postgresql.conf

postgres:~$ ls -l  /home/mloskot/data/geotiff/world.tif
-rw-r--r-- 1 mloskot mloskot 411822 Apr 14  2008
/home/mloskot/data/geotiff/world.tif

postgres:~$ gdalinfo  /home/mloskot/data/geotiff/world.tif
Driver: GTiff/GeoTIFF
Files: /home/mloskot/data/geotiff/world.tif
       /home/mloskot/data/geotiff/world.tif.aux.xml
Size is 512, 256
...


So, user postgres has access to the the world.tif file owned by user mloskot.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net