Tom Lane writes:
I don't have the patience to run this for 10^8 rows, but the test case
I got suspicious of my 'test' file so I took 1000 rows. That had problems and pointed out problems with the file.
It seems I had mismatched single quotes.. my guess is that psql got confused and went into into an infinite loop somewhow. With the 1000 rows sample it reported the error. I am re-doing the input file.