René, You are probably missing tiger in your database search path. When you restore a database, it doesn't restore the search path so you have to run something like: ALTER DATABASE yourdatabase SET search_path=public, tiger; Hope that helps, Regina http://www.postgis.us
_____ From: [email protected] [mailto:[email protected]] On Behalf Of René Fournier Sent: Thursday, October 27, 2011 1:51 AM To: PostGIS Users Discussion Subject: [postgis-users] PostGIS 1.5.3 and Tiger Geocoder after restore 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
