Forum OpenACS Q&A: Response to Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command

Did you remember to add $PGHOME/lib to your LD_LIBRARY_PATH?  That's the first thing I would check.