Now i'm having another error. I created another post: "Problem with postgis raster using gdal_translate"
thanks! Virginia On Fri, Jun 3, 2011 at 8:49 PM, Paragon Corporation <[email protected]> wrote: > Virginia, > > I see your table is mixed casing in you statement. Is your table mixed > case in PostgreSQL. Not sure if gdal_translate takes your casing literally > or not. > > I would suggest making sure all your tables are lower case in the > database and lower case in your gdal_translate as well just to make sure. > > Leo > http://www.postgis.us > > > ------------------------------ > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Virginia > Maffei > *Sent:* Friday, June 03, 2011 1:49 PM > *To:* PostGIS Users Discussion > *Subject:* Re: [postgis-users] Gdal translate Error checking geometry type > existence problem > > Hi, thanks for the response. > In the gdal directory y executed this line: > > C:\Archivos de programa\GDAL>gdal_translate PG:"dbname=template_postgis20 > user=postgres table=HumedadDeExtincion mode=2" your_file.tif > > > Does it have something wrong? > thanks! > Virginia > > 2011/6/3 Jorge Arévalo <[email protected]> > >> Hi Virginia, >> >> This is a GDAL driver's issue, not PostGIS Raster one. Did you use a >> where clause with unescaped single quotes in your connection string? >> This is a common error. Anyway, could you send me the gdal_translate >> line that caused the error? >> >> As Pierre said, it isn't a good idea to use template_postgis20 to >> store data. Create a new database using the templated instead: >> >> createdb -T template_postgis20 -U <your_user> -W testing_db >> >> Best regards, >> Jorge >> >> On Fri, Jun 3, 2011 at 1:24 PM, Pierre Racine >> <[email protected]> wrote: >> > Did you load/execute rtpostgis.sql in the database? >> > >> > >> > >> > Also, I think this is not good practice to use your template database >> > (template_postgis20) to store data. >> > >> > >> > >> > Pierre >> > >> > >> > >> > From: [email protected] >> > [mailto:[email protected]] On Behalf Of >> Virginia >> > Maffei >> > Sent: Thursday, June 02, 2011 8:22 PM >> > To: PostGIS Users Discussion >> > Subject: [postgis-users] Gdal translate Error checking geometry type >> > existence problem >> > >> > >> > >> > Hi, i loaded a tif with raster2pgsql into the database and now i'm >> trying to >> > get from that table a tif with gdal_translate. >> > >> > But this error appears: >> > >> > >> > >> > C:\Archivos de programa\GDAL>gdal_translate >> PG:"dbname=template_postgis20 >> > user=postgres table=HumedadDeExtincion mode=2" your_file.tif >> > >> > ERROR 1: Error checking geometry type existence. Is PostGIS correctly >> > >> > installed?: no connection to the server >> > >> > >> > >> > GDALOpen failed - 1 >> > >> > Error checking geometry type existence. Is PostGIS correctly installed?: >> no >> > connection to the server >> > >> > >> > >> > I installed in windows the postgis raster with gdal, python, etc. >> > >> > >> > >> > Could you please help me with this problem? >> > >> > >> > >> > Thanks! >> > >> > >> > >> > Virginia >> > >> > >> > >> > >> > >> > _______________________________________________ >> > postgis-users mailing list >> > [email protected] >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> > >> >> >> >> -- >> Jorge Arévalo >> Internet & Mobilty Division, DEIMOS >> [email protected] >> http://es.linkedin.com/in/jorgearevalo80 >> http://mobility.grupodeimos.com/ >> http://gis4free.wordpress.com >> http://geohash.org/ezjqgrgzz0g >> _______________________________________________ >> 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
