If you are going to "make" the DBD::Pg module from source, you may need to get a copy of the postgreSQL source code from www.postgresql.org. IIRC, the modules depends on the libs and includes-- even requiring you to set environment variables! So much for
perl -MCPAN -e "shell install DBD::Pg". :)
There is also an
excellent book on postgreSQL which used to be in PDF but is now available on the web using HTML. While most of the book is devoted to the DBMS itself and is very good, the chapter on the Perl bindings is pitiful.
But using
DBI and
DBD::Pg, you will likely find the perldoc for each of these to be informative.