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
But there were a few notices/errors on the import:
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:54: ERROR: type "box2d"
already exists
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:63: ERROR: function
"box2d_in" already exists with same argument types
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:74: ERROR: function
"box2d_out" already exists with same argument types
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:89: ERROR: type "box2d"
already exists
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:98: ERROR: type "box3d"
already exists
[..many more…]
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:2328993: ERROR: duplicate key
value violates unique constraint "spatial_ref_sys_pkey"
DETAIL: Key (srid)=(3819) already exists.
CONTEXT: COPY spatial_ref_sys, line 1: "3819 EPSG 3819
GEOGCS["HD1909",DATUM["Hungarian_Datum_1909",SPHEROID["Bessel
1841",6377397.155,299.1..."
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:208533404: ERROR: multiple
primary keys for table "geometry_columns" are not allowed
psql:/Volumes/Extra/GC/USA/dump/gc4-20111023.sql:208533524: ERROR: multiple
primary keys for table "spatial_ref_sys" are not allowed
Still, the whole thing (~87GB) seems to have imported anyway. But now, I try to
use it:
gc4=# SELECT g.rating,
ST_X(geomout) As lon,
ST_Y(geomout) As lat, (addy).*
FROM geocode('1731 New Hampshire Avenue Northwest, Washington, DC 20010', 1) As
g;
ERROR: function geocode(unknown, integer) does not exist
LINE 4: FROM geocode('1731 New Hampshire Avenue Northwest, Washingto...
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
gc4=#
What did I miss??
…Rene_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
