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

[Nicolas Ribot]

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 <bkfitz at 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 at 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 at 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.Racine at 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-bounces at postgis.refractions.net
>> > [mailto:postgis-users-
>> > bounces at 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.francois at 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-bounces at 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
>> >       bkfitz at gmail.com
>> >       803.426.3469
>> >       ---------------------------------------
>> >
>> >
>> >       _______________________________________________
>> >       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
>> > ---------------------------------------
>>
>> _______________________________________________
>> 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
> ---------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>