Test-TempDatabase is dangerous. It is a test module but requires PostgreSQL superuser privilege. Running potentially-may-have-bug test suites with superuser privilege is out of mind.
This is especially true for us CPAN testers. We CPAN testers run tests for tens of unknown modules per day from all over the world. Not knowing what module we are testing but requiring us to grant a superuser privilege, is insane.
It is more reasonable to ask the PostgreSQL group to add a â€œcreate temporarily databaseâ€ non-superuser privilege than using this module.