I downloaded Postgresql 6.5 and compiled it under SuSE Linux 6.0, and I have an error in the middle of compiling. it cannot find pgconnect.h in the pgconnect.cc on line 24.
I ran ./configure --with-perl --with-tcl --with-odbc --with-template=linux_i386 --with-CXX=gcc and it ran successfully.