Thread: Postgres connection error

Postgres connection error

From
Vernon Van Zandt
Date:
Greetings,

I keep getting the following error when attempting to establish a
connection (from Perl):

install_driver(Pg) failed: DBD::Pg object version undef does not match
bootstrap parameter 2.2.2 at /usr/lib/perl/5.8/DynaLoader.pm line 245.

Here's the body of code used to connect:
sub db_connect {
  my $dbname = shift;
  my $host = shift;
  my $user = shift;
  my $pass = shift;
  my %db_attr = (
    PrintError => 0,
    RaiseError => 0,
  );

  my $dsn = "DBI:Pg:dbname=$dbname;host=$host"; my $db =
DBI->connect($dsn, $user, $pass, \%db_attr) or die "Can't connect() to
database $dbname: +$DBI::errstr";
  return ($db);
}

Am I in error here, or ...? We're running Debian Linux (etch, I think...).

TIA, -Vern

Attachment

Re: Postgres connection error

From
"Douglas McNaught"
Date:
On 3/18/08, Vernon Van Zandt <vernon.vanzandt@orionnetworksolutions.com> wrote:
> Greetings,
>
>  I keep getting the following error when attempting to establish a
>  connection (from Perl):
>
>  install_driver(Pg) failed: DBD::Pg object version undef does not match
>  bootstrap parameter 2.2.2 at /usr/lib/perl/5.8/DynaLoader.pm line 245.

That would seem to indicate something went wrong with your DBD::Pg
install.  Did you compile it yourself or install it as a Debian
package?

-Doug