DBD/Pg/Pg.so problem -- keeps coming back

[erick_paper]

I keep getting these messages. All Perl modules are installed. What am I missing?

I need Postgesql, but I do not need Perl with it. We use PHP to access it.

What is this message and how to get rid of it?!!!

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Pg/Pg.so' for module DBD::Pg: libpq.so.4: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at - line 1
Compilation failed in require at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============

[cPanelMichael]

Hello

Could you confirm the method you used to install PostgreSQL?

It's generally advised that you use the method documented at:

Installing PostgreSQL

If you have used the reccomended method to install PostgreSQL and continue to receive this error message, please feel free to open a support ticket for this issue so we can investigate further for you:

Submit A Ticket

Thank you.

[erick_paper]

This "recommended method" is a joke because it installs a highly insecure, highly unstable ANCIENT version of postgresql which is utterly useless for any serious production environment.

When cpanel comes up with a modern and adult way of installing the latest stable version of this massively important open source database (more important these days than the inconsistent mysql) then perhaps I'll use the recommended way.

I installed Postgresql 9.0.4 (64 bit) from RPMs as described on the postgresql website.

Any ideas?

[gbromios]

Just chiming in here with my findings here; one of the boxes on our network is sending the same message, and when I try to install DBD::Pg through CPAN, it errors out with the following:

****************
WARNING! DBD::Pg no longer supports versions less than 7.4.
You must upgrade PostgreSQL to a newer version.
****************

Indeed, the current postgres on the server is 7.3. I'm not sure if updating it's going to be viable, since it's on CentOS 3.9, so we might just end up migrating it.

[gkgcpanel]

Hello

Could you confirm the method you used to install PostgreSQL?

It's generally advised that you use the method documented at:

Installing PostgreSQL

If you have used the reccomended method to install PostgreSQL and continue to receive this error message, please feel free to open a support ticket for this issue so we can investigate further for you:

Submit A Ticket

Thank you.

We just got this too, while upgrading to 11.30 STABLE on one of our servers. (others have been upgraded without problems).
The strange thing is, that we don't have PostGreSQL on this particular server. Never had it there. We only have PG on one server and it was already successfully upgraded.

So why would Pg.pm be failing if PostGreSQL is not even installed???

[gkgcpanel]

We just got this too, while upgrading to 11.30 STABLE on one of our servers. (others have been upgraded without problems).
The strange thing is, that we don't have PostGreSQL on this particular server. Never had it there. We only have PG on one server and it was already successfully upgraded.

So why would Pg.pm be failing if PostGreSQL is not even installed???

UPDATE: The upgrade did finish (took a lot longer than it usually does), and everything seems to be working just fine.

However, this morning, I still got another notice:

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============

Why??? and what must be done to stop these notices (other than the obvious of installing PostGreSQL, which I don't want to do...

[gkgcpanel]

UPDATE: The upgrade did finish (took a lot longer than it usually does), and everything seems to be working just fine.

However, this morning, I still got another notice:

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============

Why??? and what must be done to stop these notices (other than the obvious of installing PostGreSQL, which I don't want to do...

Still getting regular emails like this...

Subject: [checkperlmodules] The perl module DBD::Pg could not be installed.

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============


What needs to be done to fix this problem???

[gkgcpanel]

Did another upgrade yesterday thinking *MAYBE* it might fix this.

It didn't and I'm still getting these emails daily...

PostGreSQL is installed on this server, (just not running because it's not needed). I even tried starting it and running the upgrade again (with --force) and it still gives the same error message that Pg.pm could not be installed...

So just tried running /scripts/installpostgres...

# ./installpostgres
This script will install PostgreSQL 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!

Are you sure you wish to proceed? y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Excluding Packages in global exclude list
Finished
Setting up Install Process
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Package postgresql-8.1.23-1.el5_6.1.i386 already installed and latest version
Package postgresql-libs-8.1.23-1.el5_6.1.i386 already installed and latest version
Package postgresql-server-8.1.23-1.el5_6.1.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql-devel i386 8.1.23-1.el5_6.1 base 1.2 M

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

Total download size: 1.2 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : postgresql-devel 1/1

Installed:
postgresql-devel.i386 0:8.1.23-1.el5_6.1

Complete!
Installing Bundle:BD::Pg
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
You should now configure PostgreSQL from WHM!


Of course, we don't want to configure PostgreSQL from WHM because this server does not need it nor do we want our customers to have it.

[000]

when I try to install DBD::Pg through CPAN

How is possible install this?

Just I have same problem:

Can't locate DBD/Pg.pm...

How I can install this ?
Is possible manually ?

[storminternet]

Run

perl -MCPAN -e shell

and it will open up cpan command prompt. It's possible that you may get list of questions if you use this command for the first time.

To install DBD::Pg you just need to type

cpan> install DBD::Pg

[000]

THANKS!

Some command to check if perl module DBD::Pg is installed?
Some command to check if perl module DBD::Pg is running?
Some command to check VERSION of perl module DBD::Pg ?