Well if I leave the -F and -I in, I get the following error when I run the .sql:
psql:979801mosaic.sql:2: ERROR: relation "testmosaic" already exists. Here is what I ran: rcgeoadmin@minty ~/src/postgis-2.0.1/raster/loader $ ./raster2pgsql -s 2273 -t 256x256 -F -I /home/rcgeoadmin/temp/979903.tif public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql Processing 1/1: /home/rcgeoadmin/temp/979903.tif rcgeoadmin@minty ~/src/postgis-2.0.1/raster/loader $ ./raster2pgsql -s 2273 -t 256x256 -F -I /home/rcgeoadmin/temp/979801.tif public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql Processing 1/1: /home/rcgeoadmin/temp/979801.tif On Mon, Sep 10, 2012 at 2:22 PM, Pierre Racine <pierre.rac...@sbf.ulaval.ca>wrote: > Why did you remove the -F option in the second command? You're trying to > append less columns in an existing table. > > > -----Original Message----- > > From: postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users- > > boun...@postgis.refractions.net] On Behalf Of Brian Fitzgerald > > Sent: Monday, September 10, 2012 1:13 PM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] RE : PostGIS 2.0 Raster Mosaic... > > > > Here is what I tried without luck: > > > > Step 1 : ./raster2pgsql -s 2273 -t 256x256 -F -I > > /home/rcgeoadmin/temp/979903.tif public.testmosaic > > > /home/rcgeoadmin/temp/979903mosaic.sql > > Step 2: psql -d mydb -f 979903mosaic.sql > > Step 3: ./raster2pgsql -s 2273 -t 256x256 -a > > /home/rcgeoadmin/temp/979801.tif public.testmosaic > > > /home/rcgeoadmin/temp/979801mosaic.sql > > Step 4: psql -d mydb -f 979801mosaic.sql > > > > > > > > > > > > On Mon, Sep 10, 2012 at 12:02 PM, Francois Hugues > > <hugues.franc...@irstea.fr> wrote: > > > > > > I may be wrong but I think the problem comes from the index. You > use > > the option -I to create it but you cannot create it more than once. You > should > > just remove the -I option from the second time you use your command and I > > think it should work. > > > > Hugues. > > > > > > -------- Message d'origine-------- > > De: postgis-users-boun...@postgis.refractions.net de la part de > Brian > > Fitzgerald > > Date: lun. 10/09/2012 17:57 > > À: PostGIS Users Discussion > > Objet : [postgis-users] PostGIS 2.0 Raster Mosaic... > > > > ... trying to create a raster mosaic using the raster2pgsql > tool... I > > imported a tif image and now I want to append a second adjacent > tiff to > > the > > first one... figured I could just run the same command with -F -I > -t > > 256x256 etc and tack on the -a? I tried this and got an error > saying: > > > > 'testmosaic_raster_gist' already exists... anyone know how to > > accomplish > > this? > > > > - Brian > > > > -- > > -------------------------------------- > > Brian Fitzgerald, PMP, GISP > > bkf...@gmail.com > > 803.426.3469 > > --------------------------------------- > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > > > > > > > > -- > > -------------------------------------- > > Brian Fitzgerald, PMP, GISP > > bkf...@gmail.com > > 803.426.3469 > > --------------------------------------- > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- -------------------------------------- Brian Fitzgerald, PMP, GISP bkf...@gmail.com 803.426.3469 ---------------------------------------
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
