#1883 closed defect (fixed)
Geocoder install fails trying to run create_census_base_tables()
| Reported by: | bpanulla | Owned by: | robe |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.0.1 |
| Component: | tiger geocoder | Version: | 2.0.x |
| Keywords: | history | Cc: |
Description
I did a clean install of PostGIS 2.0 from RPM. When I started to set up the tiger2010 geocoder I saw an error in the output of create_geocode.sh
SELECT tiger.create_census_base_tables();: No such file or directory
On line 20:
${PSQL_CMD} -d "${THEDB}" -f "SELECT tiger.create_census_base_tables();"
That should probably be -c to run inline SQL rather than -f.
Change History (2)
comment:1 by , 12 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
comment:2 by , 12 years ago
| Keywords: | history added |
|---|
Note:
See TracTickets
for help on using tickets.
Thanks for the catch. Fixed at r9972 for 2.0 and r9973 for 2.1. I guess I missed it since I'm on windows and I guess I forgot to change the Linux script when I corrected the windows one.
FWIW: The PostGIS 2.1 (trunk), has tiger2011. It will work just fine with PostGIS 2.0. In fact I'm using it against my PostGIS 2.0 production install.
If you are starting out, you might want to go with that one as I hear they've made many improvements to the tiger 2011 dataset.