id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 908,Unix/Linux sh bash version of tiger2010 geocoder loader does not work,donh,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.",defect,closed,medium,PostGIS 2.0.0,tiger geocoder,master,fixed,history,