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

[Virginia Maffei]

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 <jorge.arevalo at deimos-space.com>

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110603/4065d893/attachment.html>