Hi, Leave -F to keep the column containing the name of the file and remove the -I option that creates the spatial index. You can also create the index only at the end (last image) to avoid updating the index for each new raster appended to the table
Nicolas On 11 September 2012 18:43, Brian Fitzgerald <bkf...@gmail.com> wrote: > 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 > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
