[postgis-devel] geocoder rev 7531

maplabs at light42.com maplabs at light42.com
Fri Jul 1 00:26:23 PDT 2011


>
> 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. 
>  




More information about the postgis-devel mailing list