I am not sure that Postgres needs CPAN. CPAN is particularly useful for handling dependencies. I doubt that there will be lots of dependencies in Postgres add ons. So having something like the current system where you download and build packages from source isn't going to be improved much with a CPAN like system.
