Test::PostgreSQL::v2

A modern PostgreSQL runner for Perl tests.

Why v2?

The original Test::PostgreSQL has several issues on modern Linux (Ubuntu 24.04+):

1. It looks for postmaster instead of postgres.
2. It tries to use system directories for sockets, leading to permission errors.
3. It doesn't handle modern "postgres" user role requirements well.

Test::PostgreSQL::v2 fixes these by using isolated temporary directories for sockets, providing automatic binary discovery, and allowing flexible host/user configuration.

Usage with Test::DBIx::Class

use Test::More;
use Test::DBIx::Class {
    schema_class => 'MyApp::Schema',
    traits       => ['Testpostgresqlv2'],
    deploy_db    => 1,
}, qw/:resultsets/;

ok ResultSet('User')->create({ name => 'John' }), 'Created user';

done_testing;