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: [email protected]
>Data: 04/10/2011 19.37
>A: <[email protected]>, "PostGIS Users Discussion"<postgis-
[email protected]>
>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: [email protected]
>>Data: 04/10/2011 18.52
>>A: "[email protected]"<[email protected]>, "PostGIS Users Discussion"<postgis-
>[email protected]>
>>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: [email protected] [mailto:postgis-users-
>>> [email protected]] On Behalf Of [email protected]
>>> 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: [email protected]
>>> >Data: 04/10/2011 18.39
>>> >A: "[email protected]"<[email protected]>, "PostGIS Users
>>> >Discussion"<postgis-
>>> [email protected]>
>>> >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: [email protected]
>>> >> [mailto:postgis-users- [email protected]] On Behalf Of
>>> >> [email protected]
>>> >> 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: [email protected]
>>> >> >Data: 04/10/2011 17.07
>>> >> >A: "[email protected]"<[email protected]>, "PostGIS Users
>>> >> >Discussion"<postgis-
>>> >> [email protected]>
>>> >> >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: [email protected]
>>> >> >> [mailto:postgis-users- [email protected]] On Behalf
>>> >> >> Of [email protected]
>>> >> >> Sent: Tuesday, October 04, 2011 7:30 AM
>>> >> >> To: [email protected]
>>> >> >> 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
>>> >> >> [email protected]
>>> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >> >
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> postgis-users mailing list
>>> >> [email protected]
>>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> [email protected]
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>_______________________________________________
>postgis-users mailing list
>[email protected]
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
