[postgis-users] raster2pgsql quoted string error

[jean-daniel Sylvain]

Dear list,

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.

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.

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.

By reporting this result, I hope that it will give a hint to someone for a 
potential solution.

Regards.

Jean-Daniel

Le samedi 3 novembre 2012 08:30:15 UTC-4, jean-daniel Sylvain a écrit :
>
> Good moring Bborie,
>
> First time I used this installation process on the gis4free page: 
> http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/. 
>
>
> Yesterday I used the installation provide by enterprise db (winx86-64).
>
> http://www.enterprisedb.com/products-services-training/pgdownload
>
> 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.  
>
> Hope this is clear.
>
> Jean-Daniel
>
> Le samedi 3 novembre 2012 00:20:12 UTC-4, Bborie Park a écrit :
>>
>> Hey Jean-Daniel, 
>>
>> Strange indeed.  I would know what's going on in raster2pgsql as I 
>> wrote the loader.  Which Windows installer are you using?  A link to 
>> that installer would be nice.  The same goes for all the other 
>> applications in the stack. 
>>
>> You don't need the GDAL python bindings for PostGIS. 
>>
>> -bborie 
>>
>> On Fri, Nov 2, 2012 at 6:10 PM, jean-daniel Sylvain 
>> <jeandanie... at gmail.com> wrote: 
>> > 
>> > Bborie and the list, 
>> > 
>> > 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. 
>> > 
>> > Unfortunately (beleive or not), we still had the same error message. 
>> The problem seem to appears suddenly at the end of the conversion. 
>> > 
>> > There is anyone know what are the processes involve in the raster2pgsql 
>> at this stage of conversion? 
>> > 
>> > Anyone, have an idea of what's still going wrong? 
>> > 
>> > Thanks! 
>> > 
>> > Jean-Daniel 
>> > 
>> > Le vendredi 2 novembre 2012 05:15:00 UTC-4, José Pedro Santos a écrit : 
>> >> 
>> >> Hi Jean, 
>> >> 
>> >> 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.. 
>> >> 
>> >> Best Regards, 
>> >> JSantos 
>> >> 
>> >> ________________________________ 
>> >> Date: Thu, 1 Nov 2012 15:23:25 -0400 
>> >> From: jean-dani... at mrnf.gouv.qc.ca 
>> >> To: postgi... at lists.osgeo.org 
>> >> 
>> >> Subject: Re: [postgis-users] raster2pgsql quoted string error 
>> >> 
>> >> Hi bborie 
>> >> 
>> >> I would prefer to share my computer with you  (;)). 
>> >> 
>> >> 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. 
>> >> 
>> >> I will share you a link where you will find the image with Ubuntu one. 
>> It should be down there. 
>> >> 
>> >> Hope I won't have to re-install all my gear. 
>> >> 
>> >> If it's not okay, I will send you the image via email. 
>> >> 
>> >> Jean-Daniel 
>> >> 
>> >> 
>> >> J'ai lié 1 fichier à ce courriel : 
>> >> landsat.tif(54.3 Mo)Ubuntu Onehttp://
>> ubuntuone.com/0ZJgHJwOf2GBW7n8KsnBbO 
>> >> Mozilla Thunderbird permet de partager facilement des fichiers 
>> volumineux par courriel. 
>> >> 
>> >> 
>> >> _______________________________________________ postgis-users mailing 
>> list postgi... at lists.osgeo.org 
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users 
>> > 
>> > 
>> > _______________________________________________ 
>> > postgis-users mailing list 
>> > postgi... at lists.osgeo.org 
>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users 
>> > 
>>
>>
>>
>> -- 
>> Bborie Park 
>> Programmer 
>> Center for Vectorborne Diseases 
>> UC Davis 
>> 530-752-8380 
>> bkp... at ucdavis.edu 
>> _______________________________________________ 
>> postgis-users mailing list 
>> postgi... at lists.osgeo.org 
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users 
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121112/eff52e9f/attachment-0001.html>