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

[Dan Blomberg]

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
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081216/6e6ea22a/attachment.html>