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	trunk	fixed	history