Fwd: DBI connect fails with DBD-Pg-2.12.0 but works with DBD-Pg-2.11.8

I neglected to mention a potentially crucial difference between the  
installations of DBD-Pg-2.11.8 and DBD-Pg-2.12.0 referred to below.   
The DBD-Pg-2.11.8 installation was done as root, and lives in the  
normal Perl library tree; in contrast, the DBD-Pg-2.12.0 installation  
was done as a regular user, and lives off my home directory, in ~/ 
local/test.

Thanks!

Gabriel Berriz

Begin forwarded message:

> From: Gabriel Berriz <[email protected]>
> Date: April 25, 2009 12:44:05 PM EDT
> To: [email protected]
> Cc: [email protected]
> Subject: DBI connect fails with DBD-Pg-2.12.0 but works with DBD- 
> Pg-2.11.8
>
>
>
> Hi.  I'd like to upgrade our version of DBD::Pg from 2.11.8 to  
> 2.12.0 (or higher), but 2.12.0 (the version I get when I upgrade  
> DBD::Pg from CPAN) results in a connection error that did not occur  
> with the earlier versions.  Specifically, when I attempt to run my  
> test scripts all my connection attempts fail with error messages like:
>
> DBI connect('dbname=postgres','dev',...) failed: FATAL:  role "dev"  
> does not exist at t/read.t line 442
>
> The source code line for referred to by this error message is
>
>  my $pgh = DBI->connect(
>                          'dbi:Pg:dbname=postgres',
>                          'dev', '',
>                          +{
>                             AutoCommit => 1,
>                             RaiseError => 1,
>                             PrintError => 0,
>                             PrintWarn  => 0,
>                           }
>                        );
>
>
> As far as I know, there is only one Pg server running on localhost,  
> and it uses the standard port.  For this server, contrary to what  
> the error message above says, the "dev" role most definitely  
> exists.  In fact, to get these errors to disappear (and all the  
> tests to pass) all I need to do is ensure that the version of  
> DBD::Pg that the code uses is 2.11.8 instead of 2.12.0, which  
> confirms that role "dev" does exist as expected.
>
> Does DBD-Pg-2.12.0 need a specific version of DBI?  I'm using 1.607.
>
> How can I troubleshoot this further?
>
> Thanks in advance,
>
> Gabriel Berriz
>
>
>