Now i'm having another error. I created another post: "<span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; ">Problem with postgis raster using gdal_translate"</span><div>
<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">thanks!<br>
</span></font>Virginia<br>
<br><br><div class="gmail_quote">On Fri, Jun 3, 2011 at 8:49 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Virginia,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">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.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">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.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Leo</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><div><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Virginia Maffei<br></div><b>Sent:</b> Friday, June 03, 2011 1:49 PM<br><b>To:</b>
PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] Gdal translate
Error checking geometry type existence problem<br></font><br></div><div><div></div><div>
<div></div>Hi, thanks for the response.
<div>In the gdal directory y executed this line:</div>
<div><br></div>
<div><span style="border-collapse:collapse;font-family:arial, sans-serif;font-size:13px">C:\Archivos de programa\GDAL>gdal_translate
PG:"dbname=template_postgis20 user=postgres table=HumedadDeExtincion mode=2"
your_file.tif</span></div>
<div><font face="arial, sans-serif"><span style="border-collapse:collapse"><br></span></font></div>
<div><font face="arial, sans-serif"><span style="border-collapse:collapse"><br></span></font></div>
<div><font face="arial, sans-serif"><span style="border-collapse:collapse">Does it have something
wrong?</span></font></div>
<div><font face="arial, sans-serif"><span style="border-collapse:collapse">thanks!</span></font></div>
<div><font face="arial, sans-serif"><span style="border-collapse:collapse">Virginia</span></font><br><br>
<div class="gmail_quote">2011/6/3 Jorge Arévalo <span dir="ltr"><<a href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a>></span><br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">Hi Virginia,<br><br>This is a GDAL driver's issue, not
PostGIS Raster one. Did you use a<br>where clause with unescaped single quotes
in your connection string?<br>This is a common error. Anyway, could you send
me the gdal_translate<br>line that caused the error?<br><br>As Pierre said, it
isn't a good idea to use template_postgis20 to<br>store data. Create a new
database using the templated instead:<br><br>createdb -T template_postgis20 -U
<your_user> -W testing_db<br><br>Best regards,<br>Jorge<br>
<div>
<div></div>
<div><br>On Fri, Jun 3, 2011 at 1:24 PM, Pierre Racine<br><<a href="mailto:Pierre.Racine@sbf.ulaval.ca" target="_blank">Pierre.Racine@sbf.ulaval.ca</a>>
wrote:<br>> Did you load/execute rtpostgis.sql in the
database?<br>><br>><br>><br>> Also, I think this is not good
practice to use your template database<br>> (template_postgis20) to store
data.<br>><br>><br>><br>> Pierre<br>><br>><br>><br>>
From: <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a><br>>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of Virginia<br>> Maffei<br>> Sent: Thursday, June 02, 2011
8:22 PM<br>> To: PostGIS Users Discussion<br>> Subject: [postgis-users]
Gdal translate Error checking geometry type<br>> existence
problem<br>><br>><br>><br>> Hi, i loaded a tif with
raster2pgsql into the database and now i'm trying to<br>> get from
that table a tif with gdal_translate.<br>><br>> But this error
appears:<br>><br>><br>><br>> C:\Archivos de
programa\GDAL>gdal_translate PG:"dbname=template_postgis20<br>>
user=postgres table=HumedadDeExtincion mode=2" your_file.tif<br>><br>>
ERROR 1: Error checking geometry type existence. Is PostGIS
correctly<br>><br>> installed?: no connection to
the server<br>><br>><br>><br>> GDALOpen failed - 1<br>><br>>
Error checking geometry type existence. Is PostGIS correctly installed?:
no<br>> connection to the server<br>><br>><br>><br>> I
installed in windows the postgis raster with gdal, python,
etc.<br>><br>><br>><br>> Could you please help me with this
problem?<br>><br>><br>><br>>
Thanks!<br>><br>><br>><br>>
Virginia<br>><br>><br>><br>><br>><br></div></div>>
_______________________________________________<br>> postgis-users mailing
list<br>> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br><br><br><br>--<br>Jorge
Arévalo<br>Internet & Mobilty Division, DEIMOS<br><a href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a><br><a href="http://es.linkedin.com/in/jorgearevalo80" target="_blank">http://es.linkedin.com/in/jorgearevalo80</a><br>
<a href="http://mobility.grupodeimos.com/" target="_blank">http://mobility.grupodeimos.com/</a><br><a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br><a href="http://geohash.org/ezjqgrgzz0g" target="_blank">http://geohash.org/ezjqgrgzz0g</a><br>
_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>
</div>