Can't load 'c:/Perl/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg...

It's worth pointing out that DBD::Pg ships with recent versions of Strawberry Perl.
I therefore recommend installing and using Strawberry Perl if that's an option for you. (IMO, installing a "portable edition" to the location of your choosing is best.)

Cheers,
Rob