Usually tar.gz (Tarball source-code distributions) are quit easy to install.

gunzip distribution.tar.gz
tar -xvf distribution.tar
cd distribution
perl Makefile.PL
make
make test
su
make install
exit
[download]

Thats it!
I don't think RPMs are the way to go but you will find them e.g with a google search for DBD::Pg rpm.

Hanamaki