Re: PERL: Bundle::DBD::Pg

On Sat, Apr 11, 2020 at 05:26:27PM -0400, Fred Richard wrote:
> Is the PERL Module :"Bundle::DBD::Pg" using an internal Pg command?

No.

> is it possible for the Module to use the System Pg Client?
> Ex:   /usr/pgsql-12/lib/libpq.so

I wouldn't describe that as "the System Pg Client", because
/usr/pgsql-11/lib/libpq.so has an equal claim to that title.  /usr/lib/libpq.so
has a senior claim to that title.

The DBD::Pg installation process binds to a particular copy of libpq.  Search
for POSTGRES_HOME in https://github.com/bucardo/dbdpg for instructions on how to
control which copy of libpq it picks.  If you wish to change the copy it picks,
reinstall DBD::Pg.

>          /usr/pgsql-12/bin/psql
> 
> 
> 
> DBI connect('dbname=aimd;host=usawsvnadb01.net.bms.com;port=5432','aimuser',...)
> failed: SCRAM authentication requires libpq version 10 or above
> 
> PSQL COMMAND:     /usr/pgsql-12/bin/psql
>      $POSTGRES_HOME      = "/usr/pgsql-12"  ;
>      $POSTGRES_INCLUDE   = "/usr/pgsql-12/include" ;
>      $POSTGRES_LIB       = "/usr/pgsql-12/lib -lssl -lcrypto" ;
>  INSTALLED PG VERSION:  12.2
> LINUX:  RH Linux 7.7
> PERL:   5.24.x

I'm guessing your DBD::Pg installation uses /usr/lib/libpq.so.5 (PostgreSQL
9.2).