Ticket #908 (closed defect: fixed)
Unix/Linux sh bash version of tiger2010 geocoder loader does not work
|Reported by:||donh||Owned by:||robe|
ctrl-m's in the file and/or generated by psql would crash psql. Missing command line parameters would also crash it. I would generate my load_tiger script by running psql as: \a \o load_tiger \i states \o \q I would them remove the control-m's from load_tiger. tr "\r" "\n" < load_tiger > load_tiger2 I then would edit load_tiger2 putting a #!bin/bash at the top and removing the line numbers at the end. I had already downloaded the tiger database files so I would replace wget with #wget in the file. shp2pgsql does not really convert latin1 to utf-8 all the time so I added a "| iconv -f latin1 -t UTF8 | $PGBIN/psql" after the shp2pgsql command. That did away with the aborted transactions from postgresql.