[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" ;