Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#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:


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

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 Changed 6 years ago by robe

Resolution: fixed
Status: newclosed

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.

comment:2 Changed 6 years ago by robe

Keywords: history added
Note: See TracTickets for help on using tickets.