I had to edit some .sql files (those at www/doc/sql/)
because they used "/usr/local/pgsql/lib" and my postgres
installation uses "/usr/lib/pgsql"
This happened particulary in two files:
/www/doc/sql/postgres.sql and /www/doc/sql/postgres-pgtcl.sql
I hope this helps.