[postgis-users] Tiger Geocoder 2010 setup issues

[Daniel Weitzenfeld]

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/20110629/a84a3c0e/attachment.html>