postgres access via perl failing after upgrade - Mailing list pgsql-general

From Fetter, David M
Subject postgres access via perl failing after upgrade
Date
Msg-id B1F9E0D87882D21182F8006094519AD804D6D899@mwabs021.emeryworld.com
Whole thread Raw
Responses Re: postgres access via perl failing after upgrade
List pgsql-general
I'm attempting to upgrade our version of postgres from 6.4.3, which has a
couple of not too good bugs, to 7.0.2.  I can successfully upgrade, export
and import the database, however the perl scripts that we were using
(written by somebody who's gone now) no longer work.  I've traced the
problem to the following line:

$dbh = DBI->connect("dbi:Pg:dbname=$PGDB;host=$PGHOST;port=$PGPORT", , );

It looks like that at this point the script is actually trying to connect to
the database but it fails now for some reason.  This might not be enough of
the code to get an idea, but I thought perhaps it was for somebody.  Is
there anything within this connection that looks like it probably wouldn't
work after upgrading from the old version to the new?  Do I maybe need to
upgrade a perl module?  Any help, suggestions, or ideas would be
appreciated.  Thanks.


Thank you,
David M. Fetter 503.450.6609
UNIX System Analyst
Emery World Wide

"It has become appallingly clear that our technology has surpassed our
humanity." - Albert Einstein


Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select question
Next
From: Paul Caskey
Date:
Subject: Re: Speed difference between != and = operators?