Re: [bug] could not determine PostgreSQL library version

On Fri, Dec 5, 2008 at 3:22 PM, Andrew Dunstan <[email protected]> wrote:
>> I've had problems installing the latest few versions of DBD::Pg.  I've
>> ignored the issue for the most part because of lack of time, but today
>> I was able to dig into this a bit more.  Here is the build result on
>> Fedora Core 8.  I think that App::Info::RDBMS::PostgreSQL isn't
>> finding the location of some of the binaries such as initdb, but I
>> need to poke in there a bit further to be sure.
>>
>> Is this on the radar at all?  I might be able to eek out some tuits
>> for a patch before the end of the month if this isn't on the radar.  I
>> have tried upgrading to FC9 but perl is largely broken there (haven't
>> tried FC10 yet).
>>
>>
>> fred@localhost DBD-Pg-2.11.6 $ perl Makefile.PL
>> Configuring DBD::Pg 2.11.6
>> Path to pg_config?
>> Use of uninitialized value in -d at Makefile.PL line 80, <STDIN> line 1.
>> Use of uninitialized value in sprintf at Makefile.PL line 86, <STDIN> line
>> 1.
>> Use of uninitialized value in sprintf at Makefile.PL line 86, <STDIN> line
>> 1.
>> Use of uninitialized value in sprintf at Makefile.PL line 86, <STDIN> line
>> 1.
>> Use of uninitialized value in pattern match (m//) at Makefile.PL line
>> 87, <STDIN> line 1.
>> PostgreSQL version: 00000 (default port: 5432)
>> POSTGRES_HOME: /var/lib/pgsql
>> POSTGRES_INCLUDE: /usr/include
>> POSTGRES_LIB: /usr/lib
>> OS: linux
>> Could not determine the PostgreSQL library version.
>> Please ensure that a valid path is given to the 'pg_config' command,
>> either manually or by setting the environment variables
>> POSTGRES_DATA, POSTGRES_INCLUDE, and POSTGRES_LIB
>> fred@localhost DBD-Pg-2.11.6 $ cat /etc/redhat-release
>> Fedora release 8 (Werewolf)
>>
>>
>
> do you have pg_config installed? If you're using RPMs that requires the
> installation of the postgresql-devel RPM.

I thought that I had that particular rpm installed but on inspection
it wasn't.  Installing it resolved the issue.  I ran into some
roadblocks about a month ago with yum not co-operating, but it went
smoothly today.

I stepped through the inspection process (before -devel was installed)
with the perl debugger and may have a patch for App::Info that looks
in the right places if the -devel RPM isn't installed.

Thanks for the spot.