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

From Tom Lane
Subject Re: postgres access via perl failing after upgrade
Date
Msg-id 19142.965083581@sss.pgh.pa.us
Whole thread Raw
In response to postgres access via perl failing after upgrade  ("Fetter, David M" <Fetter.David@emeryworld.com>)
List pgsql-general
"Fetter, David M" <Fetter.David@emeryworld.com> writes:
> 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", , );

That will try to connect via TCP, so your problem might just be that you
didn't start the 7.0 postmaster with "-i" and/or didn't copy over your
old pg_hba.conf config file.  (See nearby thread about PGAccess
connect problems.)

If it's not that, we'll need to know exactly why it's failing to
connect.  There should be an error message coming out someplace ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Fetter, David M"
Date:
Subject: postgres perl DBI
Next
From: Tom Lane
Date:
Subject: Re: Corrupted Table