[postgis-users] PostGIS 1.5.3 and Tiger Geocoder after restore

[René Fournier]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111026/2e5f8457/attachment.html>