[postgis-users] PostGIS 2.0 Raster Mosaic...

[Pierre Racine]

Put the -C option just in the last command. If you put it in the first, the max extent constraint prevent the table from accepting more tiles (unless you put -C with -x).

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Brian Fitzgerald
> Sent: Tuesday, September 11, 2012 1:10 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] PostGIS 2.0 Raster Mosaic...
> 
> I just tried the following (following your example) and get the following error:
> 
> ./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif
> public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql
> 
> psql -d mydb -f 979801mosaic.sql
> 
> ./raster2pgsql -a -s 2273 -t 256x256 -M -F /home/rcgeoadmin/temp/979903.tif
> public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql
> 
> psql -d mydb -f 979903mosaic.sql
> 
> 
> ERROR:
> 
> postgres at minty /home/rcgeoadmin/temp $ psql -d mydb -f 979903mosaic.sql
> BEGIN
> psql:979903mosaic.sql:2: ERROR:  new row for relation "testmosaic" violates
> check constraint "enforce_max_extent_rast"
> psql:979903mosaic.sql:3: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:979903mosaic.sql:4: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> .....
> 
> 
> 
> On Tue, Sep 11, 2012 at 12:57 PM, Markus Innerebner
> <markus.innerebner at inf.unibz.it> wrote:
> 
> 
> 	I am doing the same thing with success:
> 
> 	use my script:
> 
> 	cheers Markus
> 
> 	*************
> 	param 1: name the directory in which the files are located
> 	param2: name of the table in which the files are loaded
> 	*************
> 	more raster2pgHydroalp.sh
> 	#!/bin/bash
> 	# this script imports raster ascii file into postgis
> 	#
> 	isFirst=true;
> 	cd $1;
> 
> 	for i in $(\ls *.asc);
> 	  do
> 	  echo $i
> 	  if $isFirst
> 	  then
> 	   raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d
> hydroalp';
> 	   isFirst=false
> 	  else
> 	   raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d
> hydroalp'
> 	  fi
> 	done
> 
> 	cd ..
> 
> 	***********
> 
> 
> 
> 	--
> 	Ph D. Student Markus Innerebner
> 
> 	DIS Research Group - Faculty of Computer Science
> 	Free University Bozen-Bolzano
> 
> 	Dominikanerplatz 3 - Room 211
> 	I - 39100 Bozen
> 	Phone:  +39-0471-016143 <tel:%2B39-0471-016143>
> 	Mobile: +39-333-9392929 <tel:%2B39-333-9392929>
> 
> 
> 	gpg --fingerprint
> 	-------------------------------------
> 	pub   1024D/588F6308 2007-01-09
> 	      Key fingerprint = 6948 947E CBD2 89FD E773  E863 914F EB1B 588F
> 6308
> 	sub   2048g/BF4877D0 2007-01-09
> 
> 
> 	On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:
> 
> 
> 		979903mosaic.sql
> 
> 
> 
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at postgis.refractions.net
> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> 
> 
> --
> --------------------------------------
> Brian Fitzgerald, PMP, GISP
> bkfitz at gmail.com
> 803.426.3469
> ---------------------------------------