If you are having trouble installing DBD-Pg, the Perl PostgreSQL interface module, under MacOS 10.3, make sure you do the following before running the make process:
tcsh version:
% setenv POSTGRES_LIB "/usr/local/pgsql/lib -lssl -lcrypto"
% setenv POSTGRES_INCLUDE /usr/local/pgsql/include
% setenv POSTGRES_HOME /usr/local/pgsql
bash version:
% export POSTGRES_LIB="/usr/local/pgsql/lib -lssl -lcrypto"
% export POSTGRES_INCLUDE=/usr/local/pgsql/include
% export POSTGRES_HOME=/usr/local/pgsql
And remember that the final make install should really be sudo make install. Don't run the prior perl Makefile.PL, make and make test commands with sudo; either run them as you, or su or login as root, and run the entire process, including the setting of the three variables, as root.
Explanation:
If you leave off the -lssl, the perl Makefile.PL will fail, and if you leave off the -lcrypto, the make will fail. The documentation "suggests" adding these flags, and perhaps it wasn't completely mandatory in Jaguar, but they're definitely required in Panther.
Mac OS X Hints
http://hints.macworld.com/article.php?story=20040313152730927