[postgis-users] Gdal translate Error checking geometry type existence problem

[Jorge Arévalo]

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
<Pierre.Racine at sbf.ulaval.ca> 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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g