Strange that you're getting a process termination. The problem with loading out-db rasters was just resolved in 2.0.5 and 2.1.2...
http://postgis.net/2014/03/31/postgis-2.1.2 The specific ticket is #2607... Can you trying upgrading and see if the problem persists? I've never seen the process terminate whenever I've hit the open file limit. -bborie On Mon, Mar 31, 2014 at 9:44 AM, Robert Nix <[email protected]> wrote: > After 1001 of these errors: > > 2014-03-31 15:50:51 UTC ERROR: rt_band_load_offline_data: Cannot open > offline raster: /... > > > I get: > > SELECT: rt_api.c:8659: rt_raster_from_band: Assertion `((void *)0) != > raster' failed. > 2014-03-31 15:50:52 UTC LOG: server process (PID 8385) was terminated by > signal 6: Aborted > > > Eventually resulting in: > > 2014-03-31 15:50:52 UTC FATAL: the database system is in recovery mode > > > Requiring bouncing the postgres service. > > I'm not sure if this is an issue with PostGIS or PostgreSQL itself. > > I'm accessing the rasters from within a sql function, essentially: > > st_setbandnodatavalue( > st_snaptogrid( > st_setsrid(_rast,4326), > gridx:=st_upperleftx(_rast), > gridy:=st_upperlefty(_rast) > ), > 0.0 > ) > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
