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
