Dear list,<br><br>I'm now on the last version published by environmental DB (postgresql 9.2 64 bits) and still on windows 7 with a postgis 2.0.1 installation.<br><br>Following the issues mentionned in the previous post, I tried several approaches to use raster2pgsql to load a raster in postgis. We have added environmental variables, we have desactivated the firewall, antivirus but nothing still works.We also compare our two set-up of windows-7 using EVEREST Ultimate Edition (trial version) and we have also founded nothing there.<br><br>We gave a try to theextension "Load Postgis Raster to QGIS' provided by Mauricio de Paulo (v. 0.5.4) and everything works well. Unfortunately, this solution is not optimal if we want to upload many,many,many rasters in the database.<br><br>By reporting this result, I hope that it will give a hint to someone for a potential solution.<br><br>Regards.<br><br>Jean-Daniel<br><br>Le samedi 3 novembre 2012 08:30:15 UTC-4, jean-daniel Sylvain a écrit :<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;">Good moring Bborie,<br><br>First time I used this installation process on the gis4free page: <a href="http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/" target="_blank">http://gis4free.wordpress.com/<wbr>2011/03/10/how-to-install-and-<wbr>configure-postgis-raster-on-<wbr>windows/</a>. <br><br>Yesterday I used the installation provide by enterprise db (winx86-64).<br><br><a href="http://www.enterprisedb.com/products-services-training/pgdownload" target="_blank">http://www.enterprisedb.com/<wbr>products-services-training/<wbr>pgdownload</a><br><br>I don't think the problem is directly related to raster2pgsql, since it works on similar installation/computer. Do you think it could be related to computer setting used by raster2pgsql (regional settings, encoding). It was why I was askinf what are the processes involved in raster2pgsql at this stage. <br><br>Hope this is clear.<br><br>Jean-Daniel<br><br>Le samedi 3 novembre 2012 00:20:12 UTC-4, Bborie Park a écrit :<blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">Hey Jean-Daniel,
<br>
<br>Strange indeed. I would know what's going on in raster2pgsql as I
<br>wrote the loader. Which Windows installer are you using? A link to
<br>that installer would be nice. The same goes for all the other
<br>applications in the stack.
<br>
<br>You don't need the GDAL python bindings for PostGIS.
<br>
<br>-bborie
<br>
<br>On Fri, Nov 2, 2012 at 6:10 PM, jean-daniel Sylvain
<br><<a>jeandanie...@gmail.com</a>> wrote:
<br>>
<br>> Bborie and the list,
<br>>
<br>> We have uninstall everything could have potential link with postgresSQL/postGIS, GDAL and GDAL python binding and proceed to a hole new installation via the package provide by enterprise DB (V. 9.2.1 Winx86-64). We were very optmistic to have a pretty new update installation that will convert and insert this raster through the database.
<br>>
<br>> Unfortunately (beleive or not), we still had the same error message. The problem seem to appears suddenly at the end of the conversion.
<br>>
<br>> There is anyone know what are the processes involve in the raster2pgsql at this stage of conversion?
<br>>
<br>> Anyone, have an idea of what's still going wrong?
<br>>
<br>> Thanks!
<br>>
<br>> Jean-Daniel
<br>>
<br>> Le vendredi 2 novembre 2012 05:15:00 UTC-4, José Pedro Santos a écrit :
<br>>>
<br>>> Hi Jean,
<br>>>
<br>>> The raster2psql is well install? You can import other raster files? If yes is very strange that error and also if the data is good..
<br>>>
<br>>> Best Regards,
<br>>> JSantos
<br>>>
<br>>> ______________________________<wbr>__
<br>>> Date: Thu, 1 Nov 2012 15:23:25 -0400
<br>>> From: <a>jean-dani...@mrnf.gouv.qc.ca</a>
<br>>> To: <a>postgi...@lists.osgeo.org</a>
<br>>>
<br>>> Subject: Re: [postgis-users] raster2pgsql quoted string error
<br>>>
<br>>> Hi bborie
<br>>>
<br>>> I would prefer to share my computer with you (;)).
<br>>>
<br>>> Seriously, I don't think the problem is with the raster. We imported the same image in an other postgis database (version 2.0) without any problem. I try to import several others images with my raster2pgsql and we still have the same result.
<br>>>
<br>>> I will share you a link where you will find the image with Ubuntu one. It should be down there.
<br>>>
<br>>> Hope I won't have to re-install all my gear.
<br>>>
<br>>> If it's not okay, I will send you the image via email.
<br>>>
<br>>> Jean-Daniel
<br>>>
<br>>>
<br>>> J'ai lié 1 fichier à ce courriel :
<br>>> landsat.tif(54.3 Mo)Ubuntu Onehttp://<a href="http://ubuntuone.com/0ZJgHJwOf2GBW7n8KsnBbO" target="_blank">ubuntuone.com/<wbr>0ZJgHJwOf2GBW7n8KsnBbO</a>
<br>>> Mozilla Thunderbird permet de partager facilement des fichiers volumineux par courriel.
<br>>>
<br>>>
<br>>> ______________________________<wbr>_________________ postgis-users mailing list <a>postgi...@lists.osgeo.org</a> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<wbr>bin/mailman/listinfo/postgis-<wbr>users</a>
<br>>
<br>>
<br>> ______________________________<wbr>_________________
<br>> postgis-users mailing list
<br>> <a>postgi...@lists.osgeo.org</a>
<br>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<wbr>bin/mailman/listinfo/postgis-<wbr>users</a>
<br>>
<br>
<br>
<br>
<br>--
<br>Bborie Park
<br>Programmer
<br>Center for Vectorborne Diseases
<br>UC Davis
<br>530-752-8380
<br><a>bkp...@ucdavis.edu</a>
<br>______________________________<wbr>_________________
<br>postgis-users mailing list
<br><a>postgi...@lists.osgeo.org</a>
<br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<wbr>bin/mailman/listinfo/postgis-<wbr>users</a>
<br></blockquote></blockquote>