checking libpq-fe.h usability... no
checking libpq-fe.h presence... no
checking for libpq-fe.h... no
configure: error: Unable to find libpq-fe.h
ttyp8:makoto@st4200  23:11:18/050225(...local-src/manitou-0.9.4)> 

何かな ? postgresql が要るっていうことらしい。client にも ? Looks like postgresql should be installed. Then what is the point to pickup:

ttypf:makoto@st4200  23:23:31/050225(...powerpc/All)> ls -l postgre*
-rw-r--r--  1 root  wheel   370817 Feb 22 16:13 postgresql73-client-7.3.9.tgz
-rw-r--r--  1 root  wheel   641429 Feb 21 00:04 postgresql73-lib-7.3.9.tgz
-rw-r--r--  1 root  wheel  2823308 Feb 25 21:14 postgresql73-server-7.3.9.tgz
-rw-r--r--  1 root  wheel     3262 Feb 25 21:09 postgresql74-7.4.7.tgz
-rw-r--r--  1 root  wheel   906508 Feb 22 16:11 postgresql74-client-7.4.7.tgz
-rw-r--r--  1 root  wheel   450806 Feb 22 16:08 postgresql74-contrib-7.4.7.tgz
-rw-r--r--  1 root  wheel  1898231 Feb 20 23:01 postgresql74-docs-7.4.7.tgz
-rw-r--r--  1 root  wheel   842113 Feb 21 00:02 postgresql74-lib-7.4.7.tgz
-rw-r--r--  1 root  wheel  3565914 Feb 25 21:08 postgresql74-server-7.4.7.tgz
-rw-r--r--  1 root  wheel    21756 Feb 23 17:37 postgresql_autodoc-1.24.tgz
-rw-r--r--  1 root  wheel    28655 Feb 24 04:21 postgrey-1.17nb1.tgz
ttypf:makoto@st4200  23:23:34/050225(...powerpc/All)> 

should be postgresql74-7.4.7.tgz pkg_info postgresql74-7.4.7.tgz said

...
This is the meta-package for the PostgreSQL database system.

ttyp9:makoto@st4200 19:16:09/050225(...powerpc/All)> sudo pkg_add postgresql74-7.4.7.tgz
Password:
pkg_add: pkg `postgresql74-client>=7.4.7' required, but `postgresql74-client-7.4.6nb1' found installed.
pkg_add: pkg `postgresql74-server>=7.4.7' required, but `postgresql74-server-7.4.6nb3' found installed.
pkg_add: Please resolve this conflict!
pkg_add: 2 package additions failed

374 23:26 sudo pkg_add postgresql74-7.4.7.tgz
375 23:27 sudo pkg_delete -f postgresql74-client-7.4.6nb1
376 23:27 sudo pkg_delete -f postgresql74-server-7.4.6nb3
377 23:28 sudo pkg_add postgresql74-7.4.7.tgz
378 23:28 pkg_info | grep postgres
379 23:28 sudo pkg_delete -f postgresql74-lib
380 23:29 sudo pkg_delete -f php-pgsql
381 23:29 sudo pkg_add postgresql74-7.4.7.tgz
382 23:29 sudo pkg_add php-pgsql-4.3.10.tgz

It is not a trivial work at this time of late night:

..
checking libpq-fe.h usability... no
checking libpq-fe.h presence... no
checking for libpq-fe.h... no
configure: error: Unable to find libpq-fe.h

Nothing changed: ??

ttyp9:makoto@st4200 23:34:49/050225(...local-src/manitou-0.9.4)> find /usr/pkg -name libpq-fe.h
/usr/pkg/include/libpq-fe.h

./configure --with-pgsql-includes=/usr/pkg/include

will get pass above problem, then I've got

checking for PQconnectdb in -lpq... no
configure: error: Unable to use -lpq

./configure --with-pgsql-includes=/usr/pkg/include -with-pgsql-libs=/usr/pkg/lib

...
checking for IceConnectionNumber in -lICE... yes
checking for Qt... ls: /lib/libqt*: No such file or directory
ls: /usr/lib/libqt*: No such file or directory
ls: /usr/local/lib/libqt*: No such file or directory
ls: /opt/lib/libqt*: No such file or directory
no
configure: creating ./config.status
..

ttyp9:makoto@st4200 23:46:11/050225(...powerpc/All)> sudo pkg_add qt2-libs-2.3.1nb6.tgz

Then I got pkg_info -D screen

ttyp9:makoto@st4200  23:53:01/050225(...local-src/manitou-0.9.4)> \
./configure \
--with-pgsql-includes=/usr/pkg/include \
--with-pgsql-libs=/usr/pkg/lib \
--with-Qt-dir=/usr/pkg/qt2
ttyp9:makoto@st4200  23:53:03/050225(...local-src/manitou-0.9.4)> 

In file included from /usr/include/g++/bits/gthr-default.h:40,
                 from /usr/include/g++/bits/gthr.h:101,
                 from /usr/include/g++/bits/c++io.h:37,
                 from /usr/include/g++/bits/fpos.h:44,
                 from /usr/include/g++/iosfwd:49,
                 from /usr/include/g++/bits/stl_algobase.h:70,
                 from /usr/include/g++/bits/stl_tree.h:86,
                 from /usr/include/g++/map:66,
                 from main.h:42,
                 from main.cpp:25:
/usr/pkg/include/pthread.h:285: error: conflicting types for `typedef struct 
   pthread_st*pthread_t'
/usr/include/pthread_types.h:71: error: previous declaration as `typedef struct 
   __pthread_st*pthread_t'

It looks like /usr/pkg/inclue/pthread.h and /usr/include/pthread_types.h are conflicting:

> find /usr/include /usr/pkg/include -name pthre\* -ls
   17666 Feb 15 23:47 /usr/include/g++/bits/pthread_allocimpl.h
    6885 Feb 15 23:46 /usr/include/pthread_dbg.h
   13444 Feb 15 23:46 /usr/include/pthread.h
p    5379 Feb 15 23:46 /usr/include/pthread_queue.h
    6976 Feb 15 23:46 /usr/include/pthread_types.h
   20463 Jan  7 14:11 /usr/pkg/include/pthread.h