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

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111027/f9855b78/attachment.html>