Re: DBI::Pg problems

On Wed, Jun 06, 2001 at 08:01:14AM -0400, Chris Hayner wrote:
> Good Morning All,
>
> I am having all kinds of problems with the DBI::Pg module. Installing
> (mistakenly) as root, everything works fine. However, when I redo the
> install as a normal user as per the instructions i read a little late, I
> get the following error message.
>
>
> ld.so.1: perl: fatal: relocation error: file
> /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Pg/Pg.so:
> symbol PQconnectdb: referenced symbol not found
>
> Any assistance would be greatly appreciated.

From the README to 0.96 or later:

> If you get an error message like:
> perl: error while loading shared libraries:
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Pg/Pg.so: undefined
> symbol: PQconnectdb
> when you call DBI->connect, then your libpq.so was probably not seen at
> build-time. This should have caused 'make test' to fail; did you really
> run it and look at the output? Check the setting of POSTGRES_LIB and
> recompile DBD-Pg.

That's off a Linux box but you seem to have the Solaris equivalent.
Quick reminder:

1 Set POSTGRES_INCLUDE and POSTGRES_LIB
2 perl Makefile.pl
3 make
4 make test
5 su
6 make install

Richard