<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true">So… I've done a clean/fresh install of PostgreSQL 9.2 and PostGIS 2.1.0 via MacPorts (thanks Vincent). Installed the requisite extensions:</div><div apple-content-edited="true"><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div apple-content-edited="true"><div>CREATE EXTENSION postgis;</div></div><div apple-content-edited="true"><div>CREATE EXTENSION postgis_topology;</div></div><div apple-content-edited="true"><div>CREATE EXTENSION postgis_tiger_geocoder;</div></div><div apple-content-edited="true"><br></div></blockquote>Tested the basics:<div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div>gc5=# SELECT na.address, na.streetname,na.streettypeabbrev, na.zip</div><div>gc5-# FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na;</div><div> address | streetname | streettypeabbrev | zip </div><div>---------+------------+------------------+-------</div><div> 1 | Devonshire | Pl | 02109</div><div>(1 row)</div></div><div><br></div></blockquote>Then, to get the data (Tiger 2012), generated the loader script and ran it:<br><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><br></div></blockquote><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div apple-content-edited="true">gc5=# SELECT loader_generate_script(ARRAY['MA','RI'], 'sh') AS result;</div></div></blockquote><div><div><br></div><div>Bash script downloaded and added Massachusetts and Rhode Island without complaint, also ran:</div><div><br></div></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div>SELECT install_missing_indexes();</div></div></blockquote><div><div><br></div><div>But when I try to geocode or reverse geocode, I get nothing:</div><div><br></div></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div><div>gc5=# SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat, </div></div></div><div><div><div> (addy).address As stno, (addy).streetname As street, </div></div></div><div><div><div> (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip </div></div></div><div><div><div> FROM geocode('75 State Street, Boston MA 02109') As g;</div></div></div><div><div><div> rating | lon | lat | stno | street | styp | city | st | zip </div></div></div><div><div><div>--------+-----+-----+------+--------+------+------+----+-----</div></div></div></blockquote><div><div><br></div></div><div>There's clearly a lot of data in my geocoder DB:</div><div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div> gc5 | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 | | 1194 MB | pg_default | </div></div></blockquote><div><br></div><div>But I can't get anything from it… My previous 1.5.x PostGIS tiger geocoder was working fine… I must be missing something obvious. Can anyone point it out for me?</div><div><br></div><div>…Rene</div></body></html>