OK, I am so confused. I now recall that I actually formated and reinstalled the OS with pgsql because the default was messing me up. I then installed pgsql as directed in openacs install guide, however, I installed postgresql-7.2.1. The directions didn't call for "make --install-all-headers", so that I didn't do it.
Since I followed the directions exactly as the install guide specified, does anyone know what needs to be done? It seems that if others followed the install guide this must be a known issue.