Test::postgresql automatically setups a postgresql instance in a temporary directory, and destroys it when the perl script exits.