Yay!! When I set LD_LIBRARY_PATH then things work correctly. Your patience and help is very much appreciated. If you are ever in the Boston area I will buy you a beer.Obviously not :-(. This should be pointing to /usr/local/pgsql_8.0b3/lib/ so it seems you didn't do the rpath enabling correctly; or maybe your system is configured in a way that overrides rpath (do you have LD_LIBRARY_PATH set in your environment?).
I don't have any more advice than that to give; you may need to find aOne final question, I used the following to configure the build. Did I do something to cause the library to not link properly or do I need to find a Linux shared-library guru?
Linux shared-library guru to help you fix it.
./configure --prefix=/usr/local/pgsql_8.0b3 --with-pgport=5480 --with-perl --with-python --with-tcl --enable-thread-safety --enable-debug --enable-cassert --enable-depend
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html