I use Test::PostgreSQL for that all the time, in my applications. I usually don't for my CPAN modules, though SQL::Translator's tests conditionally check for it and SKIP otherwise.