To install the PostgreSQL interface for Perl (perl-DBD-Pg) on a system running CentOS or Red Hat Enterprise Linux, you can use the yum package manager.
First, make sure that the EPEL repository is enabled on your system. You can check if it is enabled by running the following command:
yum repolist enabled | grep epel
If the EPEL repository is not enabled, you can enable it by following the instructions on the EPEL repository page (https://fedoraproject.org/wiki/EPEL).
Once the EPEL repository is enabled, you can install the perl-DBD-Pg package using the following command:
sudo yum install perl-DBD-Pg
The package will be installed, along with any required dependencies. You can verify the installation by running the following command:
perl -MDBI -e 'print $DBI::VERSION,"\n"'
This should print the version of the DBI module, which provides a database-independent interface for Perl, and includes support for PostgreSQL through the perl-DBD-Pg package.
Once the package is installed, you can use Perl scripts to connect to a PostgreSQL database and perform various database operations, such as querying and updating data. You can find more information on using the DBI module in the Perl documentation and the perl-DBD-Pg module documentation.