<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I had the Tiger Geocoder 2010 working great on one machine. I dumped the database to a file, and then restored it to a fresh Postgresql90 + PostGIS 1.5.3 (a la Macports)… via psql -U postgres -q -d gc4 -f tiger_dump.sql<div><br></div><div>But there were a few notices/errors on the import:</div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><br></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:54: ERROR: type "box2d" already exists</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:63: ERROR: function "box2d_in" already exists with same argument types</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:74: ERROR: function "box2d_out" already exists with same argument types</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:89: ERROR: type "box2d" already exists</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:98: ERROR: type "box3d" already exists</div></div><div>[..many more…]</div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:2328993: ERROR: duplicate key value violates unique constraint "spatial_ref_sys_pkey"</div></div><div><div>DETAIL: Key (srid)=(3819) already exists.</div></div><div><div>CONTEXT: COPY spatial_ref_sys, line 1: "3819<span class="Apple-tab-span" style="white-space:pre"> </span>EPSG<span class="Apple-tab-span" style="white-space:pre"> </span>3819<span class="Apple-tab-span" style="white-space:pre"> </span>GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel 1841",6377397.155,299.1..."</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:208533404: ERROR: multiple primary keys for table "geometry_columns" are not allowed</div></div><div><div>psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:208533524: ERROR: multiple primary keys for table "spatial_ref_sys" are not allowed</div></div></blockquote><div><br></div><div>Still, the whole thing (~87GB) seems to have imported anyway. But now, I try to use it:</div><div><br></div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div>gc4=# SELECT g.rating, </div></div><div><div>ST_X(geomout) As lon, </div></div><div><div>ST_Y(geomout) As lat, (addy).* </div></div><div><div>FROM geocode('1731 New Hampshire Avenue Northwest, Washington, DC 20010', 1) As g;</div></div><div><div>ERROR: function geocode(unknown, integer) does not exist</div></div><div><div>LINE 4: FROM geocode('1731 New Hampshire Avenue Northwest, Washingto...</div></div><div><div> ^</div></div><div><div>HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div></div><div><div>gc4=# </div></div></blockquote><div><br></div><div>What did I miss??</div><div><br></div><div>…Rene</div></body></html>