[ic] Trouble accessing PostgreSQL

Dan B interchange-users@lists.akopia.com
Mon May 14 17:01:01 2001


At 04:26 PM 5/14/2001 -0400, you wrote:
>on RedHat 6.2; postgresql-7.1.0
>test.pl has no trouble connecting to the database.
>When I start Akopia, I get the following error:
>
> >Configuring catalog construct...Using PostgreSQL, 
> DSN=dbi:Pg:dbname=test_construct.
> >construct config error: connect failed (create) -- unknown error. Driver 
> 'Pg' installed?
>
>Evidently, Interchange is not find the database driver. The interchange user
>has these environment settings:
>
> >export PATH=$PATH:/usr/local/pgsql/bin
> >export PGDATA=/usr/local/pgsql/data
> >export LD_LIBRARY_PATH=/usr/local/pgsql/lib
> >export PGLIB=/usr/local/pgsql/lib
>
>Are other environment settings needed, or is there something in the config
>file that needs changing, or what?
>
>TIA,
>Jacques Williams

Sounds like DBD::Pg isn't installed.

Barring the use of Bundle::Interchange, one can download DBD::Pg manually 
from search.cpan.org (which I think is the easiest way), and then tar zxvf 
..., then
perl Makefile.PL
make
make test
make install

And that's it.

HTH,

Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com