[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