Thank you for all your help - I got it to work! For posterity, the postgis-related fixes I made: -unmarked the ALTER DATABASE line in create_geocode.sh -changed pg_hba.conf to trust, trust, trust -tweaked a file with a name like "postgis conf" to allow access on port 5432 -added the projections.sql file to my postgis-enabled db
I also had a bunch of silly problems related to my mediocre linux skills, e.g. -wget wasn't working because I didn't have permissions to create a directory -I hadn't installed unzip Basically I was in over my head but I surfaced. The precision from the geocodes I've run so far has been really amazing, good stuff Regina and Leo! On Wed, Jun 29, 2011 at 12:13 PM, Paragon Corporation <[email protected]> wrote: > ** > 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:* [email protected] [mailto: > [email protected]] *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 <[email protected]> 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: [email protected] >> [mailto:[email protected]] On Behalf Of >> Daniel >> Weitzenfeld >> Sent: Tuesday, June 28, 2011 6:51 AM >> To: [email protected] >> 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 >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
