<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18157" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=557462903-17122008><FONT face=Arial
color=#0000ff size=2>Dan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=557462903-17122008><FONT face=Arial
color=#0000ff size=2>I </FONT></SPAN><SPAN class=557462903-17122008><FONT
face=Arial color=#0000ff size=2>did a process monitor on it and confirmed it is
connecting to my postgresql server fine (or at least what I could tell) so seems
to be on writing the output that it has an issue. I sent Mark the process
monitor trace off list to see if he can make more sense of it than I can.
At least I think we have a good idea of the spot in the code where it is
crashing.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=557462903-17122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=557462903-17122008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=557462903-17122008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Dan
Blomberg<BR><B>Sent:</B> Tuesday, December 16, 2008 10:13 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] pgsql2shp.exe
fails with Windows Vista<BR></FONT><BR></DIV>
<DIV></DIV>I am running it with commands. This is what I'm
running:<BR><BR>"c:\Program Files\PostgreSQL\8.3\bin>
<DIV class="ArwC7c ckChnd" id=:8b><WBR>pgsql2shp.exe -f contours.shp -u postgres
postgis contours<BR>Initializing... Done (postgis major version: 1).<BR>Output
shape: PolyLine<BR>Dumping: X"<BR><BR>It crashes at the X and does exactly what
Regina is saying (those three files empty). The same command works fine on
XP.<BR><BR>Dan<BR></DIV><BR>Paragon Corporation wrote:
<BLOCKQUOTE cite=mid:0FB76F04CCBF4CDE87C2DB0C14791BE4@H type="cite"><PRE wrap="">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 [<A class=moz-txt-link-freetext href="mailto:lr@pcorp.us">mailto:lr@pcorp.us</A>]
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: <A class=moz-txt-link-abbreviated href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>
[<A class=moz-txt-link-freetext href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] 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:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">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.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
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?
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">In VS 2008 - just tells me binary not built with debug info.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
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 <A class=moz-txt-link-freetext href="http://www.siriusit.co.uk">http://www.siriusit.co.uk</A>
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE></BODY></HTML>