[postgis-users] pgsql2shp.exe fails with Windows Vista

[Dan Blomberg]

Thanks Regina,

That worked great on Vista and XP for me.  It did not automatically 
create a .prj file.  Perhaps how I loaded it didn't let it know the 
projection?

Dan

Paragon Corporation wrote:
> Hmm it appears it got stripped.  You can download from here.
>  
> http://www.bostongis.com/downloads/pgutils/pgsql2shp136patched.zip
>  
> Anyrate let me know if it fixes your Vista problem.  It also 
> automatically creates a .prj file.  If you can test that out that 
> would be great too.
>  
> Thanks,
> Regina
>  
>  
>
> ------------------------------------------------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] *On Behalf Of 
> *Paragon Corporation
> *Sent:* Thursday, December 18, 2008 5:50 PM
> *To:* 'PostGIS Users Discussion'
> *Subject:* RE: [postgis-users] pgsql2shp.exe fails with Windows Vista
>
> Dan,
>  
> Can you try this 1.3.6 patched version for me and see if it works.  I 
> tried this on my Windows Xp and Windows Vista boxes and it worked fine 
> on both.  If it works okay for you and verified it doesn't mess any 
> Linux user up, then I'll commit to 1.3 branch.
>  
> Thanks,
> Regina
>  
>
> ------------------------------------------------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] *On Behalf Of 
> *Dan Blomberg
> *Sent:* Tuesday, December 16, 2008 10:13 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] pgsql2shp.exe fails with Windows Vista
>
> I am running it with commands.  This is what I'm running:
>
> "c:\Program Files\PostgreSQL\8.3\bin>
> pgsql2shp.exe -f contours.shp -u postgres postgis contours
> Initializing... Done (postgis major version: 1).
> Output shape: PolyLine
> Dumping: X"
>
> It crashes at the X and does exactly what Regina is saying (those 
> three files empty).  The same command works fine on XP.
>
> Dan
>
> Paragon Corporation wrote:
>> I mean XP and 2000 boxes all works fine.  Vista  is broken for pgsql2shp but
>> works fine  for psql and shp2pgsql.
>>
>> It couldn't be some dumb thing like because I presume psql was compiled with
>> VC++ and pgsql2shp I presume was compiled with MingW? (all are stack builder
>> installs at anyrate)
>>
>> -----Original Message-----
>> From: Paragon Corporation [mailto:lr at pcorp.us] 
>> Sent: Tuesday, December 16, 2008 9:48 PM
>> To: 'PostGIS Users Discussion'
>> Subject: RE: [postgis-users] pgsql2shp.exe fails with Windows Vista
>>
>> Mark,
>> I was running it with command line options to output the file.  
>>
>> Without options it works fine.  
>>
>> It gets as far as creating the .shp, .dbf, .shx before it crashes.  All 3
>> files are pretty empty except some weird header gobbly gook so I guess its
>> when its getting into the loop to start reading the data so you could be
>> right about the libpq.  
>>
>> Though if libpq were the problem, wouldn't I have the same issue running
>> psql and psql works fine.
>>
>> As a side note -- shp2pgsql works fine though that doesn't depend on libpq
>> anyway.
>>
>>
>> Not sure it matters, but I don't actually have PostgreSQL installed on my
>> Vista, so I'm just running from a folder with psql, pg_dump, libpq etc and
>> all the dependency files in the folder, which works perfectly fine on my XP
>> and Vista boxes.
>>
>>
>> Thanks,
>> Regina
>>
>>  
>>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
>> Cave-Ayland
>> Sent: Tuesday, December 16, 2008 7:08 PM
>> To: PostGIS Users Discussion
>> Subject: Re: [postgis-users] pgsql2shp.exe fails with Windows Vista
>>
>> Paragon Corporation wrote:
>>
>>   
>>> Oops sent too quickly.  Gives
>>>
>>> Unhandled exception at 0x76f8814c in pgsql2shp.exe: 0xC0000005: Access 
>>> violation reading location 0x01ce2882.
>>>
>>> Unfortunately I'm not good at debugging c code.  Mark does the above 
>>> message mean anything to you.
>>>     
>>
>> Only that pgsql2shp is trying to do something that Vista doesn't like? 
>> Could it be related to pgsql2shp trying to locate libpq.dll? I guess this is
>> just running pgsql2shp without any additional command line options?
>>
>>   
>>> In VS 2008 - just tells me binary not built with debug info.
>>>     
>>
>> That's correct, the installer versions are stripped to remove the debug to
>> keep the sizes down. I have the original unstripped versions here, but I'm
>> fairly certain that gdb/MSVC have different debug info formats. 
>> Hence if you want to debug, you'll need these unstripped versions and a copy
>> of MSYS/gdb on your Vista box to get a backtrace.
>>
>>
>> ATB,
>>
>> Mark.
>>
>> --
>> Mark Cave-Ayland
>> Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk
>> T: +44 870 608 0063
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/20081220/66c9ec58/attachment.html>