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

Sat Dec 20 14:44:16 PST 2008

Dan,
Great.  Thanks for testing this out for us.  As far as the .prj, it won't
create one if your srid is -1.  However in all other cases it should if your
spatial_ref_sys table is loaded.

To force it, say your data is in long lat -- try doing something like

pgsql2shp -f C:\test -h t -p 5433 -u postgres mydatabase "SELECT gid,
ST_SetSRID(the_geom, 4326) As the_geom FROM sometable"

And it should create a .prj file with WGS 84 stuff in it.

Similarly if your data does have an SRID - you can force into another
projection by doing something like

pgsql2shp -f C:\test -h t -p 5433 -u postgres mydatabase "SELECT gid,
ST_Transform(the_geom, 4326) As the_geom FROM sometable"

Hope that helps,
Regina

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dan
Blomberg
Sent: Saturday, December 20, 2008 4:29 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pgsql2shp.exe fails with Windows Vista

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/9bf0c4a9/attachment.html>