[postgis-users] R: R: RE: Problems adding postgis raster data to db
dany_x at inwind.it
dany_x at inwind.it
Wed Oct 5 00:24:12 PDT 2011
Good Morning,
this are the commands i give to my bash:
..../clip$ python /usr/lib/postgresql/8.4/bin/raster2pgsql.py -r cliptavag.tif
-t tavag -o tavag.sql -s 32633 -k 50x50 -I
------------------------------------------------------------
Summary of GDAL to PostGIS Raster processing:
------------------------------------------------------------
Number of processed raster files: 1 (cliptavag.tif)
List of generated tables (number of tiles):
1 tavag (11088)
.../clip$ psql -U dermap -d raster -f tavag.sql
addrastercolumn
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
public.tavag.rast srid:32633 pixel_types:{16BUI,16BUI,16BUI} out_db:false
regular_blocking:true nodata_values:'{65535,65535,65535}' scale_x:'0.4999569'
scale_y:'-0.49995690000006' blocksize_x:'50' blocksize_y:'50' extent:POLYGON
((360718.287740393 5106518.39173093,360718.287740393
5108308.73738983,364560.956473793 5108308.73738983,364560.956473793
5106518.39173093,360718.287740393 5106518.39173093))
(1 row)
(END)
and it's stuck again near (END) for about ten minutes now.
DC
>----Messaggio originale----
>Da: dany_x at inwind.it
>Data: 04/10/2011 19.37
>A: <Pierre.Racine at sbf.ulaval.ca>, "PostGIS Users Discussion"<postgis-
users at postgis.refractions.net>
>Ogg: [postgis-users] R: RE: R: RE: R: RE: Problems adding postgis raster data
to db
>
>
>no problem loading shapefile. This is a problem i have on work, tomorrow in
>the morning i will post more logs.
>Thanky you very much.
>
>>----Messaggio originale----
>>Da: Pierre.Racine at sbf.ulaval.ca
>>Data: 04/10/2011 18.52
>>A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users Discussion"<postgis-
>users at postgis.refractions.net>
>>Ogg: RE: [postgis-users] R: RE: R: RE: Problems adding postgis raster data
to
>db
>>
>>Loading a shapefile works fine? Any more informative log?
>>
>>> -----Original Message-----
>>> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>>> bounces at postgis.refractions.net] On Behalf Of dany_x at inwind.it
>>> Sent: Tuesday, October 04, 2011 12:50 PM
>>> To: PostGIS Users Discussion
>>> Subject: [postgis-users] R: RE: R: RE: Problems adding postgis raster
data
>to db
>>>
>>> No table was added by the process. if i try to close the Terminal it says
>that
>>> there's a process still running but with the command top i can't see it
>using cpu
>>>
>>> >----Messaggio originale----
>>> >Da: Pierre.Racine at sbf.ulaval.ca
>>> >Data: 04/10/2011 18.39
>>> >A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users
>>> >Discussion"<postgis-
>>> users at postgis.refractions.net>
>>> >Ogg: RE: [postgis-users] R: RE: Problems adding postgis raster data to
>>> >db
>>> >
>>> >Even if the cursor is still flashing, did you check if the table was
>>> >well
>>> created?
>>> >
>>> >> -----Original Message-----
>>> >> From: postgis-users-bounces at postgis.refractions.net
>>> >> [mailto:postgis-users- bounces at postgis.refractions.net] On Behalf Of
>>> >> dany_x at inwind.it
>>> >> Sent: Tuesday, October 04, 2011 12:36 PM
>>> >> To: PostGIS Users Discussion
>>> >> Subject: [postgis-users] R: RE: Problems adding postgis raster data
>>> >> to db
>>> >>
>>> >> Thank you for the answer. I already created the .sql file with -k
>>> >> 50x50 -I
>>> options.
>>> >>
>>> >> >----Messaggio originale----
>>> >> >Da: Pierre.Racine at sbf.ulaval.ca
>>> >> >Data: 04/10/2011 17.07
>>> >> >A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users
>>> >> >Discussion"<postgis-
>>> >> users at postgis.refractions.net>
>>> >> >Ogg: RE: [postgis-users] Problems adding postgis raster data to db
>>> >> >
>>> >> >What if you tile the raster using the -k 100x100 -I options of
>>> raster2pgsql?
>>> >> Same problem?
>>> >> >
>>> >> >> -----Original Message-----
>>> >> >> From: postgis-users-bounces at postgis.refractions.net
>>> >> >> [mailto:postgis-users- bounces at postgis.refractions.net] On Behalf
>>> >> >> Of dany_x at inwind.it
>>> >> >> Sent: Tuesday, October 04, 2011 7:30 AM
>>> >> >> To: postgis-users at postgis.refractions.net
>>> >> >> Subject: [postgis-users] Problems adding postgis raster data to db
>>> >> >>
>>> >> >> Hi everyone,
>>> >> >> i have problems executing the .sql file i created with
>>> >> >> raster2pgsql to my
>>> >> >> postgres9.0-postgis2.0 db.
>>> >> >> The creation of the .sql from a .tiff went trought without a
>>> >> >> problem, but
>>> >> when i
>>> >> >> try the simple command psql -U user -d db -f raster.sql all i
>>> >> >> receive is addrastercolumn
>>> >> >>
>>> >> >>
>>> >>
>>>
>--------------------------------------------------------------------------------------------------
>>> >> >>
>>> >>
>>>
>--------------------------------------------------------------------------------------------------
>>> >> >>
>>> >>
>>>
>--------------------------------------------------------------------------------------------------
>>> >> >>
>>> >>
>>>
>--------------------------------------------------------------------------------------------------
>>> >> >> -----------
>>> >> >> public.tavag.rast srid:32633 pixel_types:{16BUI,16BUI,16BUI}
>>> >> >> out_db:false regular_blocking:true
>nodata_values:'{65535,65535,65535}'
>>> >> scale_x:'0.4999569'
>>> >> >> scale_y:'-0.49995690000006' blocksize_x:'50' blocksize_y:'50'
extent:
>>> >> POLYGON
>>> >> >> ((360718.287740393 5106518.39173093,360718.287740393
>>> >> >> 5108308.73738983,364560.956473793
>>> >> 5108308.73738983,364560.956473793
>>> >> >> 5106518.39173093,360718.287740393 5106518.39173093))
>>> >> >> (1 row)
>>> >> >>
>>> >> >> (END)
>>> >> >>
>>> >> >> with the cursor flashing near the (END).... i've tried waiting 30
>>> >> >> and more minutes, but nothing.
>>> >> >> The .tiff file is 170mb and the .sql 390mb.
>>> >> >>
>>> >> >> Any ideas?
>>> >> >>
>>> >> >> Thank you,
>>> >> >> DC
>>> >> >> _______________________________________________
>>> >> >> postgis-users mailing list
>>> >> >> postgis-users at postgis.refractions.net
>>> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >> >
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> postgis-users mailing list
>>> >> postgis-users at postgis.refractions.net
>>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
More information about the postgis-users
mailing list