PERL: Bundle::DBD::Pg

--000000000000dcea1705a30a82b7
Content-Type: text/plain; charset="UTF-8"

[email protected]

Is the PERL Module :"Bundle::DBD::Pg" using an internal Pg command?
is it possible for the Module to use the System Pg Client?
Ex:   /usr/pgsql-12/lib/libpq.so
         /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
  my $dbh = DBI -> connect("DBI:Pg:dbname=$DBNAME;host=$HOST;port=$PORT",
                             $USER,
                             $PASS,
                            {AutoCommit => 0, RaiseError => 1}
                     ) or die "Database connection not made: $DBI::errstr" ;

--000000000000dcea1705a30a82b7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><a href=3D"mailto:[email protected]" class=3D"gmail-Yh1nIb g=
mail-asUmFb gmail-AL18ce" target=3D"_blank" style=3D"text-decoration-line:n=
one;color:rgb(60,64,67);overflow:hidden;text-overflow:ellipsis;white-space:=
nowrap;font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:=
13px">[email protected]</a>=C2=A0<div><br></div><div>Is the PERL Module :&quo=
t;Bundle::DBD::Pg&quot; using an internal Pg command?</div><div>is it possi=
ble for the Module to use the System Pg Client?</div><div>Ex:=C2=A0 =C2=A0/=
usr/pgsql-12/lib/libpq.so</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0

/usr/pgsql-12/bin/psql=C2=A0</div><div><br></div><div><br></div><div><br></=
div><div>DBI connect(&#39;dbname=3Daimd;host=3D<a href=3D"http://usawsvnadb=
01.net.bms.com">usawsvnadb01.net.bms.com</a>;port=3D5432&#39;,&#39;aimuser&=
#39;,...) failed: SCRAM authentication requires libpq version 10 or above<b=
r></div><div><br></div><div>PSQL COMMAND:=C2=A0 =C2=A0 =C2=A0/usr/pgsql-12/=
bin/psql<br></div><div>=C2=A0 =C2=A0 =C2=A0$POSTGRES_HOME =C2=A0 =C2=A0 =C2=
=A0=3D &quot;/usr/pgsql-12&quot; =C2=A0;<br>=C2=A0 =C2=A0 =C2=A0$POSTGRES_I=
NCLUDE =C2=A0 =3D &quot;/usr/pgsql-12/include&quot; ;<br>=C2=A0 =C2=A0 =C2=
=A0$POSTGRES_LIB =C2=A0 =C2=A0 =C2=A0 =3D &quot;/usr/pgsql-12/lib -lssl -lc=
rypto&quot; ;<br></div><div>=C2=A0INSTALLED PG VERSION:=C2=A0 12.2<br></div=
><div>LINUX:=C2=A0 RH Linux 7.7=C2=A0</div><div>PERL:=C2=A0 =C2=A05.24.x=C2=
=A0</div><div>=C2=A0 my $dbh =3D DBI -&gt; connect(&quot;DBI:Pg:dbname=3D$D=
BNAME;host=3D$HOST;port=3D$PORT&quot;,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0$U=
SER,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0$PASS,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 {Aut=
oCommit =3D&gt; 0, RaiseError =3D&gt; 1}<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0) or die &quot;Database connec=
tion not made: $DBI::errstr&quot; ;<br></div></div>

--000000000000dcea1705a30a82b7--