<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17622"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>Daniel,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>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. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>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+.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>Did you verify you have a tiger schema in your database and
that it does have tables -- addr, county, edges, faces
etc?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>From the addr fatal error you described we guessed 1 of 3
things was happening</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>a) Your script was pointing at the wrong database and not the
one you loaded tiger in</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>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</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=446040302-29062011><FONT color=#0000ff
size=2 face=Arial>c) Your database just doesn't have the skeleton and lookup
tables or is missing one of them </FONT></SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2
face=Arial> </FONT></SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2 face=Arial>Regina and
Leo,</FONT></SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><SPAN
class=446040302-29062011> </SPAN></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><FONT size=2
face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Daniel Weitzenfeld<BR><B>Sent:</B> Tuesday, June 28, 2011 6:52
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
Tiger Geocoder 2010 setup issues<BR></FONT><BR></DIV>
<DIV></DIV>Thank you Regina and Leo. It sounds like I might have a version
issue. <BR><BR>I'm using PostGIS 1.5.3, as per the installation instructions
here: <A
href="http://postgis.refractions.net/docs/ch02.html">http://postgis.refractions.net/docs/ch02.html</A><BR><BR>When
you suggested redownloading, did you mean all of PostGIS, or just the
geocoder?<BR><BR>Is the code here the up to date version? here = <A
href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/">http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/</A><BR><FONT
style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>Because in
tiger_loader.sql at that location, there's the line:<BR></FONT><PRE><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2>E'STATEDIR="${staging_fold}/${website_root}/${state_fold}"<BR>
<BR>Is that the fixed version? <BR><BR>In the meantime, I'll work on my ident issues. <BR></FONT></PRE><BR><BR><BR><BR><BR><BR>
<DIV class=gmail_quote>On Tue, Jun 28, 2011 at 11:46 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Daniel,<BR><BR>Haven't had a chance to recheck our script to
confirm its not something<BR>amiss.<BR><BR>Which version of PostGIS are
you working with?<BR><BR> You can ignore the does not exist, skipping
errors -- those are trying to<BR>drop tables which wouldn't exist for new
installs.<BR><BR>The addr does not exist often happens if you don't have tiger
in your<BR>database search_path. Make sure its in your search_path.
Also you can<BR>verify the table exists<BR>By making sure you have a
tiger schema and it has tables like addr, edges<BR>etc.<BR><BR>Regarding your
ident problem.<BR><BR>PostgreSQL can listen on localhost or local port and
depending on which that<BR>has to be registered in pg_hba.conf<BR><BR>You can
try taking out the PGHOST line since you may be running only on a<BR>non-IP
port and see if that helps or change your pg_hba.conf to
allow.<BR><BR>Regarding this issue:<BR>
<DIV class=im>STATEDIR="/gisdata/<A
href="http://www2.census.gov/geo/pvs/tiger2010st/36_New_York"
target=_blank>www2.census.gov/geo/pvs/tiger2010st/36_New_York</A>"<BR><BR>especially
because an early command is<BR><BR> cd $STATEDIR<BR><BR></DIV>I'm pretty
sure we fixed that so I suspect your version is probably out of<BR>data and
you may want to just redownload from PostGIS site (either the SVN<BR>tar ball
or directly from svn)<BR><BR>Regina and Leo<BR><A href="http://www.postgis.us"
target=_blank>http://www.postgis.us</A><BR><BR><BR>-----Original
Message-----<BR>From: <A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A><BR>[mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>]
On Behalf Of Daniel<BR>Weitzenfeld<BR>Sent: Tuesday, June 28, 2011 6:51
AM<BR>To: <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>Subject:
[postgis-users] Tiger Geocoder 2010 setup issues<BR>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>Hi,<BR>I'm trying to setup the TIGER Geocoder, following the
readme here:<BR><A
href="http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README"
target=_blank>http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/README</A><BR>I'm
setting it up on a centos 5.5 server.<BR>My questions are below, organized by
the step in the README.<BR><BR>------| Step 3. Edit the tiger_loader.sql
to the paths of your<BR>executables server etc.<BR>Is the UNZIPTOOL variable
supposed to be changed, or left at its
default?<BR>UNZIPTOOL=unzip<BR><BR>------| Step 4. Edit the
create_geocode.bat or create_geocode.sh and<BR>------| run<BR><BR>When I ran
the file, I got a boatload of NOTICEs like the following,<BR>interspersed
throughout the output:<BR><BR>psql:tables/lookup_tables_2010.sql:4: NOTICE:
table "direction_lookup" does<BR>not exist,
skipping<BR>psql:tables/lookup_tables_2010.sql:39: NOTICE:
table<BR>"secondary_unit_lookup" does not exist, skipping<BR><BR>Is this
something I should be concerned about? Did I skip
something?<BR><BR>Perhaps more alarmingly, the output finished with
this:<BR><BR>COMMIT<BR>ERROR: relation "addr" does not
exist<BR><BR>Again, what should I do?<BR><BR>------| 8. Run this command at
psql or pgAdmin III query window to<BR>generate the script.<BR>The first line
of the generated script doesn't look right:<BR><BR>STATEDIR="/gisdata/<A
href="http://www2.census.gov/geo/pvs/tiger2010st/36_New_York"
target=_blank>www2.census.gov/geo/pvs/tiger2010st/36_New_York</A>"<BR><BR>especially
because an early command is<BR><BR> cd $STATEDIR<BR><BR>Also, when I try
to run the generated script anyway, I get a boatload of<BR>these:<BR><BR>psql:
FATAL: Ident authentication failed for user "daniel"<BR><BR>...which is
strange to me because I user I thought user daniel had rights on<BR>the
PGDATABASE. Indeed, user daniel can create/delete schemas on it.
Am I<BR>misunderstanding something about postgres
permissions?<BR><BR>Thanks in advance for any guidance you can
provide.<BR>Best,<BR>-Daniel<BR></DIV></DIV>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>