Re: install Bundle::DB::Pg

[Grant McLean]

On Fri, 2020-02-28 at 14:38 -0600, Tim Halford wrote:
> I made a mistake installing the bundle and I can't figure out how to
> remove it so I can try again. I installed with:
> sudo perl -MCPAN -e 'install Bundle::DBD::Pg'
>
> My OS is ubuntu 18.04.4.

The DBD::Pg module is available as a package from Ubuntu, so the
simplest approach is to install that with:

sudo apt-get install libdbd-pg-perl

Then you don't need to use the cpan shell at all. If you want to find
the Ubuntu package for a module you can search like this:

apt-cache search DBD::Pg

> The error is:
> The value of POSTGRES_INCLUDE points to a non-existent
> directory: /usr/include/postgresql

If you really do need to install the very latest version of the DBD::Pg
module from CPAN, then you need to be aware that the install process has
to compile some C code and link to the postgres library 'libpq'. The
error that you quote suggests you don't have the libpq header files.
These can also be installed using an Ubuntu package:

sudo apt-get install libpq-dev

Also, if you really do need to install using the cpan shell then it's
not best practice to use sudo. The local::lib module can be used to
make either a user-specific or an application-specific lib directory and
install into that - no roor privileges required. You can install
local::lib from the Ubuntu package: liblocal-lib-perl

Regards
Grant