CentOS / RHEL: Install PostgresSQL Interface for Perl (perl-DBD-Pg)

How do I install PostgresSQL interface for perl for programming purpose under Redhat / RHEL / Fedora / CentOS Linux?

perl-DBD-Pg is an implementation of DBI (a database interface for Perl) for PostgreSQL for Perl. This packages allow you to access database environments in a standard way. The system implements each supported database environment as a DBD driver, in much the same way that hardware devices from multiple vendors can operate with different CPU platforms. You can install it as follows using the yum command:
# yum install perl-DBD-Pg
Sample outputs:

Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-Pg.x86_64 0:1.49-2.el5_3.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package         Arch       Version              Repository                Size
================================================================================
Installing:
 perl-DBD-Pg     x86_64     1.49-2.el5_3.1       rhel-x86_64-server-5     115 k

Transaction Summary
================================================================================
Install       1 Package(s)
Upgrade       0 Package(s)

Total download size: 115 k
Is this ok [y/N]: y
Downloading Packages:
perl-DBD-Pg-1.49-2.el5_3.1.x86_64.rpm                    | 115 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : perl-DBD-Pg                                              1/1 

Installed:
  perl-DBD-Pg.x86_64 0:1.49-2.el5_3.1                                           

Complete!

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

Your support makes a big difference:

I have a small favor to ask. More people are reading the nixCraft. Many of you block advertising which is your right, and advertising revenues are not sufficient to cover my operating costs. So you can see why I need to ask for your help. The nixCraft takes a lot of my time and hard work to produce. If everyone who reads nixCraft, who likes it, helps fund it, my future would be more secure. You can donate as little as $1 to support nixCraft:

1 comment

On CentOS6 I get this:
No package perl-DBD-Pg available.
I found an rpm for CentOS6 and ran:
yum install perl-DBD-Pg-2.15.1-4.el6_3.x86_64.rpm
and got:
Error: Package: perl-DBD-Pg-2.15.1-4.el6_3.x86_64 (/perl-DBD-Pg-2.15.1-4.el6_3.x86_64)
Requires: libpq.so.5()(64bit)
I have libpq.so.5 in my postgres install dir. Tried adding that dir to LD_LIBRARY_PATH and PATH and no luck.

Any Ideas?

David Nickerson says:
July 22, 2014 at 5:45 pm
On CentOS6 I get this:
No package perl-DBD-Pg available.
I found an rpm for CentOS6 and ran:
yum install perl-DBD-Pg-2.15.1-4.el6_3.x86_64.rpm
and got:
Error: Package: perl-DBD-Pg-2.15.1-4.el6_3.x86_64 (/perl-DBD-Pg-2.15.1-4.el6_3.x86_64)
Requires: libpq.so.5()(64bit)
I have libpq.so.5 in my postgres install dir. Tried adding that dir to LD_LIBRARY_PATH and PATH and no luck.
Any Ideas?

Have a question? Post it on our forum!