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:* [email protected]
[mailto:[email protected]] *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:* [email protected]
[mailto:[email protected]] *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:[email protected]]
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: [email protected]
[mailto:[email protected]] 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
