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
