[postgis-users] Tiger Geocoder 2010 setup issues

Tue Jun 28 19:13:33 PDT 2011

Daniel,

Yap.  what we had done is move the declaration up above the CD call since we
rna into same issue when testing in Linux.  As I recall I think when people
complained about the issue, the CD call came before the STATEDIR.

Regarding 1.5.3.  You should be fine to run with that.  For our production
work involving tiger geocoder, we are using PostGIS 1.5 and I think most
people are actually and just testing on PostGIS 2.0. 

However we did make changes that now require PostgreSQL 8.4 or above.  So
you need to be running at least PostGIS 1.5 and PostgreSQL 8.4+.

Did you verify you have a tiger schema in your database and that it does
have tables -- addr,  county, edges, faces etc?

>From the addr fatal error you described we guessed 1 of 3 things was
happening

a) Your script was pointing at the wrong database and not the one you loaded
tiger in
b) The tiger schema wasn't in your search path --- If you look at the
create_geocode.sh (you'll see a remarked out line to alter db to add tiger
to your database search path), this is a common mistake people make not
having that line
which causes the error you described. We left it remarked out since some
people have custom search paths and we didn't want to overwrite them.

c) Your database just doesn't have the skeleton and lookup tables or is
missing one of them 

Like I said your next issue is your pg_hba.conf or you have another instance
of PostgreSQL running and you are pointing at the wrong instance.

Regina and Leo,
http://www.postgis.us

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Daniel
Weitzenfeld
Sent: Tuesday, June 28, 2011 6:52 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Tiger Geocoder 2010 setup issues

Thank you Regina and Leo. It sounds like I might have a version issue. 

I'm using PostGIS 1.5.3, as per the installation instructions here:
http://postgis.refractions.net/docs/ch02.html

When you suggested redownloading, did you mean all of PostGIS, or just the
geocoder?

Is the code here the up to date version?  here =
http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/
Because in tiger_loader.sql at that location, there's the line:

E'STATEDIR="${staging_fold}/${website_root}/${state_fold}"

Is that the fixed version?  

In the meantime, I'll work on my ident issues. 

On Tue, Jun 28, 2011 at 11:46 PM, Paragon Corporation <lr at pcorp.us> wrote:

Daniel,

Haven't had a chance to recheck our script to confirm its not something
amiss.

Which version of PostGIS  are you working with?

 You can ignore the does not exist, skipping errors -- those are trying to
drop tables which wouldn't exist for new installs.

The addr does not exist often happens if you don't have tiger in your
database search_path.  Make sure its in your search_path.  Also you can
verify the table exists
By making sure you have a tiger schema and it has tables like addr, edges
etc.

Regarding your ident problem.

PostgreSQL can listen on localhost or local port and depending on which that
has to be registered in pg_hba.conf

You can try taking out the PGHOST line since you may be running only on a
non-IP port and see if that helps or change your pg_hba.conf to allow.

Regarding this issue:

STATEDIR="/gisdata/www2.census.gov/geo/pvs/tiger2010st/36_New_York"

especially because an early command is

 cd $STATEDIR

I'm pretty sure we fixed that so I suspect your version is probably out of
data and you may want to just redownload from PostGIS site (either the SVN
tar ball or directly from svn)

Regina and Leo
http://www.postgis.us

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Daniel
Weitzenfeld
Sent: Tuesday, June 28, 2011 6:51 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Tiger Geocoder 2010 setup issues

Hi,
I'm trying to setup the TIGER Geocoder, following the readme here:
http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README
I'm setting it up on a centos 5.5 server.
My questions are below, organized by the step in the README.

------| Step 3.  Edit the tiger_loader.sql to the paths of your
executables server etc.
Is the UNZIPTOOL variable supposed to be changed, or left at its default?
UNZIPTOOL=unzip

------| Step 4.  Edit the create_geocode.bat or create_geocode.sh and
------| run

When I ran the file, I got a boatload of NOTICEs like the following,
interspersed throughout the output:

psql:tables/lookup_tables_2010.sql:4: NOTICE:  table "direction_lookup" does
not exist, skipping
psql:tables/lookup_tables_2010.sql:39: NOTICE:  table
"secondary_unit_lookup" does not exist, skipping

Is this something I should be concerned about?  Did I skip something?

Perhaps more alarmingly, the output finished with this:

COMMIT
ERROR:  relation "addr" does not exist

Again, what should I do?

------| 8. Run this command at psql or pgAdmin III query window to
generate the script.
The first line of the generated script doesn't look right:

STATEDIR="/gisdata/www2.census.gov/geo/pvs/tiger2010st/36_New_York"

especially because an early command is

 cd $STATEDIR

Also, when I try to run the generated script anyway, I get a boatload of
these:

psql: FATAL:  Ident authentication failed for user "daniel"

...which is strange to me because I user I thought user daniel had rights on
the PGDATABASE.  Indeed, user daniel can create/delete schemas on it.  Am I
misunderstanding something about postgres permissions?

Thanks in advance for any guidance you can provide.
Best,
-Daniel

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

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