[postgis-devel] geocoder rev 7531

Paragon Corporation lr at pcorp.us
Fri Jul 1 14:27:53 PDT 2011


Are you still having issue?

Last time this happened to me on Linux, it was because I had some dangling
windows breaks in there that Linux evidentially did not appreciate.

I thought I got rid of all of those though.

Thanks,
Regina 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
maplabs at light42.com
Sent: Friday, July 01, 2011 3:26 AM
To: postgis-devel at postgis.refractions.net
Subject: Re: [postgis-devel] geocoder rev 7531


>
> Brian,
> Does your log show anything?  I just revised to force Unix line breaks 
> and also got rid of the  CREATE index call at the end which might have 
> been causing problems.

2011-06-30 21:04:06 PDT|[unknown]|4e0d4736.5557 LOG:  connection
received: host=[local]
2011-06-30 21:04:06 PDT|geocoder|4e0d4736.5557 LOG:  connection
authorized: user=dbb database=geocoder
2011-06-30 21:04:06 PDT|geocoder|4e0d4736.5557 LOG:  statement: ALTER TABLE
state_lookup ADD COLUMN statefp char(2); .. 
2011-06-30 21:13:03 PDT|[unknown]|4e0d494f.559d LOG:  connection
received: host=[local]
2011-06-30 21:13:03 PDT|dbb|4e0d494f.559d LOG:  connection authorized: 
user=dbb database=dbb
2011-06-30 21:13:21 PDT|[unknown]|4e0d4961.55a0 LOG:  connection
received: host=[local]
2011-06-30 21:13:21 PDT|geocoder|4e0d4961.55a0 LOG:  connection
authorized: user=dbb database=geocoder
2011-06-30 21:13:32 PDT|geocoder|4e0d4961.55a0 LOG:  duration: 77.251 ms 
statement: select postgis_full_version();

  nine minutes later I checked postgis_version() HTOP showed Idle in
Transaction, iir

  >
> Unfortunately not near a Linux machine at moment so can't test. 
>
> You can also remark out the line that reruns the tiger_loader.sql ..  
> I haven't changed that in a while.
>  

_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel





More information about the postgis-devel mailing list