PDA

View Full Version : DBD::Pg [error]



joaolmf
30-Jun-2014, 20:04
Hi,
I trying to run a script, but I'm getting the following error (message):

Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.

But when a try to install DBD::Pg (cpan), I get this:

Configuring DBD::Pg 3.3.0
Path to pg_config?

The problem is, I do not have pg_config on this machine.
Anyone here knows what should I do?

Thanks!

malcolmlewis
30-Jun-2014, 20:38
On Mon 30 Jun 2014 07:14:01 PM CDT, joaolmf wrote:


Hi,
I trying to run a script, but I'm getting the following error
(message):

PERHAPS THE DBD::PG PERL MODULE HASN'T BEEN FULLY INSTALLED,
OR PERHAPS THE CAPITALISATION OF 'PG' ISN'T RIGHT.

But when a try to install DBD::Pg (cpan), I get this:

CONFIGURING DBD::PG 3.3.0
PATH TO PG_CONFIG?

The problem is, I do not have pg_config on this machine.
Anyone here knows what should I do?

Thanks!




Hi
You need to install the postgresql development package from the SLE SDK
postgresql91-devel or postgresql-devel depending on which server you
installed.

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

joaolmf
30-Jun-2014, 21:01
Hi
You need to install the postgresql development package from the SLE SDK
postgresql91-devel or postgresql-devel depending on which server you
installed.

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

zypper install postgresql91-devel
Loading repository data...
Reading installed packages...
'postgresql91-devel' not found in package names. Trying capabilities.
No provider of 'postgresql91-devel' found.
Resolving package dependencies...

malcolmlewis
30-Jun-2014, 21:09
On Mon 30 Jun 2014 08:04:01 PM CDT, joaolmf wrote:


malcolmlewis;22282 Wrote:
> Hi
> You need to install the postgresql development package from the SLE
> SDK postgresql91-devel or postgresql-devel depending on which server
> you installed.
>
> --
> Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
> openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
> If you find this post helpful and are logged into the web interface,
> please show your appreciation and click on the star below... Thanks!

zypper install postgresql91-devel
Loading repository data...
Reading installed packages...
'postgresql91-devel' not found in package names. Trying capabilities.
No provider of 'postgresql91-devel' found.
Resolving package dependencies...




Hi
Have you added the SLE SDK as an add on product via YaST, so it adds
the repositories to your system?

You only need the DVD1 iso image and you can also use just the iso image
via YaST
https://download.suse.com/Download?buildid=hF8sRGTVC04~

This is assuming your on SLE 11 SP3....

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

joaolmf
01-Jul-2014, 18:29
Hi
Have you added the SLE SDK as an add on product via YaST, so it adds
the repositories to your system?

You only need the DVD1 iso image and you can also use just the iso image
via YaST
https://download.suse.com/Download?buildid=hF8sRGTVC04~

This is assuming your on SLE 11 SP3....

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Yes, I do.

i | postgresql-devel | PostgreSQL development header files and libraries | package

malcolmlewis
01-Jul-2014, 18:40
On Tue 01 Jul 2014 05:34:02 PM CDT, joaolmf wrote:


malcolmlewis;22284 Wrote:
> Hi
> Have you added the SLE SDK as an add on product via YaST, so it adds
> the repositories to your system?
>
> You only need the DVD1 iso image and you can also use just the iso
> image
> via YaST
> https://download.suse.com/Download?buildid=hF8sRGTVC04~
>
> This is assuming your on SLE 11 SP3....
>
Yes, I do.

i | postgresql-devel | PostgreSQL development header files
and libraries | package




Hi
Hmmm, maybe it's actually wanting pkg-config installed, is this
installed?

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

joaolmf
01-Jul-2014, 19:21
Yes. It is! :(

malcolmlewis
01-Jul-2014, 20:00
On Tue 01 Jul 2014 06:24:01 PM CDT, joaolmf wrote:


Yes. It is! :(




Hi
OK, so looking at the build requires for the rpm, there are only a
few...
https://build.opensuse.org/package/view_file/devel:languages:perl/perl-DBD-Pg/perl-DBD-Pg.spec?expand=1

But the do add a couple of exports..


export POSTGRES_INCLUDE=/usr/include/pgsql
export POSTGRES_LIB="%{_libdir} -lssl"

Where _libdir is for your arch.

Else download and install the rpm from devel:languages:perl?

--
Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
openSUSE 13.1 (Bottle) (x86_64) GNOME 3.10.1 Kernel 3.11.10-17-desktop
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below... Thanks!