in reply to Review and Suggestions - My First Module

You might also consider file-scoped my variables in stead of globals. This lends itself to better encapsulation, but reduces some functionality (but then again, you didn't realy want to poke your username and password from outside this module did you?)
# Postgres Username/Password $My::DB::pg_username = 'my_username'; $My::DB::pg_password = 'my_password';
becomes
# Postgres Username/Password my $pg_username = '...'; my $pg_password = '...';