Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #568 > unrolled thread

install perl DBD::Pg problem

Back to article view | Back to comp.databases.postgresql

Contents

  install perl DBD::Pg problem juliani.moon@gmail.com - 2014-05-19 14:21 -0700
    Re: install perl DBD::Pg problem Rainer Weikusat <rweikusat@mobileactivedefense.com> - 2014-05-19 22:43 +0100
      Re: install perl DBD::Pg problem Julian M <juliani.moon@gmail.com> - 2014-05-19 15:12 -0700
    Re: install perl DBD::Pg problem "Peter H. Coffin" <hellsop@ninehells.com> - 2014-05-19 17:02 -0500
    Re: install perl DBD::Pg problem Ralf Döblitz <doeblitz@doeblitz.net> - 2014-05-19 22:06 +0000

#568 — install perl DBD::Pg problem

I encounter a problem installing perl DBD::Pg on Ubuntu 
with regard to Pg information.

Here is what I did:

Ubuntu_bash> sudo apt-get install postgresql-server-dev-9.1
and it's up running.

Ubuntu_bash> sudo cpan
CPAN> install DBD::Pg
................................................
Enter a valid PostgreSQL postgres major version number 9
Enter a valid PostgreSQL postgres minor version number 1
Enter a valid PostgreSQL postgres patch version number 13
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
Enter a valid PostgreSQL postgres bin dir /usr/lib/postgresql/9.1/bin/
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
Enter a valid PostgreSQL postgres include dir /usr/lib/postgresql/9.1/lib
You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
Enter a valid PostgreSQL postgres library dir /usr/lib/postgresql/9.1/lib
PostgreSQL version: 90113 (default port: 5432)
................................................
In file included from Pg.xs:13:0:
Pg.h:35:22: fatal error: libpq-fe.h: No such file or directory
compilation terminated.
make: *** [Pg.o] Error 1
  TURNSTEP/DBD-Pg-3.2.0.tar.gz
  /usr/bin/make -- NOT OK

Could someone suggest what was wrong and how can I get by this?

Thanks in advance!

joe

[toc] | [next] | [standalone]

#569

juliani.moon@gmail.com writes:
> I encounter a problem installing perl DBD::Pg on Ubuntu 
> with regard to Pg information.
>
> Here is what I did:
>
> Ubuntu_bash> sudo apt-get install postgresql-server-dev-9.1
> and it's up running.
>
> Ubuntu_bash> sudo cpan
> CPAN> install DBD::Pg
> ................................................
> Enter a valid PostgreSQL postgres major version number 9
> Enter a valid PostgreSQL postgres minor version number 1
> Enter a valid PostgreSQL postgres patch version number 13
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres bin dir /usr/lib/postgresql/9.1/bin/
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres include dir /usr/lib/postgresql/9.1/lib
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres library dir /usr/lib/postgresql/9.1/lib
> PostgreSQL version: 90113 (default port: 5432)
> ................................................
> In file included from Pg.xs:13:0:
> Pg.h:35:22: fatal error: libpq-fe.h: No such file or directory
> compilation terminated.
> make: *** [Pg.o] Error 1
>   TURNSTEP/DBD-Pg-3.2.0.tar.gz
>   /usr/bin/make -- NOT OK
>
> Could someone suggest what was wrong and how can I get by this?

As you've probably already guessed, this means it can't find the files
necessary for interfacing with Postgres. The directories you've entered
are almost certainly bogus and I strongly suspect that the first prompts
asking for 'the valid version' already occur because the files can't be
found. You will need to determine why it doesn't find them. What I'd do
in this case would be to download (manually) the DBD::Pg source
distribution and attempt a build via

perl Makefile.PL
make

This should display the command it's actually executing (instead of the
crap quoted above) and from there, it should be possible to work out
what's going on here, eg, by running a failing command via strace and
looking for libpq-fe.h related errors in the output.

[toc] | [prev] | [next] | [standalone]

#570

Thank you Rainer,
That strategy helped to solve the problem when I track it down the classical way.  There was multiple copies of 'Driver.xst' found in the path.

Best regards, joe


On Monday, May 19, 2014 4:43:21 PM UTC-5, Rainer Weikusat wrote:

> > Could someone suggest what was wrong and how can I get by this?
> 
> As you've probably already guessed, this means it can't find the files
> necessary for interfacing with Postgres. The directories you've entered
> are almost certainly bogus and I strongly suspect that the first prompts
> asking for 'the valid version' already occur because the files can't be
> found. You will need to determine why it doesn't find them. What I'd do
> in this case would be to download (manually) the DBD::Pg source
> distribution and attempt a build via
> 
> perl Makefile.PL
> make
> 
> This should display the command it's actually executing (instead of the
> crap quoted above) and from there, it should be possible to work out
> what's going on here, eg, by running a failing command via strace and
> looking for libpq-fe.h related errors in the output.

[toc] | [prev] | [next] | [standalone]

#571

On Mon, 19 May 2014 14:21:38 -0700 (PDT), juliani.moon@gmail.com wrote:
> I encounter a problem installing perl DBD::Pg on Ubuntu 
> with regard to Pg information.
>
> Here is what I did:
>
> Ubuntu_bash> sudo apt-get install postgresql-server-dev-9.1
> and it's up running.
>
> Ubuntu_bash> sudo cpan
> CPAN> install DBD::Pg
> ................................................
> Enter a valid PostgreSQL postgres major version number 9
> Enter a valid PostgreSQL postgres minor version number 1
> Enter a valid PostgreSQL postgres patch version number 13
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres bin dir /usr/lib/postgresql/9.1/bin/
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres include dir /usr/lib/postgresql/9.1/lib
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
> Enter a valid PostgreSQL postgres library dir /usr/lib/postgresql/9.1/lib
> PostgreSQL version: 90113 (default port: 5432)
> ................................................
> In file included from Pg.xs:13:0:
> Pg.h:35:22: fatal error: libpq-fe.h: No such file or directory
> compilation terminated.
> make: *** [Pg.o] Error 1
>   TURNSTEP/DBD-Pg-3.2.0.tar.gz
>   /usr/bin/make -- NOT OK
>
> Could someone suggest what was wrong and how can I get by this?

CPAN isn't finding your postgres install. Where is your libpq-fe.h file?
What is output of 

Ubuntu_bash> pg_config --includedir 

?

-- 
59. I will never build a sentient computer smarter than I am.
	--Peter Anspach's list of things to do as an Evil Overlord

[toc] | [prev] | [next] | [standalone]

#572

juliani.moon@gmail.com wrote:
> I encounter a problem installing perl DBD::Pg on Ubuntu 
> with regard to Pg information.
> 
> Here is what I did:
> 
> Ubuntu_bash> sudo apt-get install postgresql-server-dev-9.1
> and it's up running.
> 
> Ubuntu_bash> sudo cpan
> CPAN> install DBD::Pg
> ................................................
> Enter a valid PostgreSQL postgres major version number 9
> Enter a valid PostgreSQL postgres minor version number 1
> Enter a valid PostgreSQL postgres patch version number 13
> You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.
                                                                                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

[...]
> Pg.h:35:22: fatal error: libpq-fe.h: No such file or directory
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

[...]
> Could someone suggest what was wrong and how can I get by this?

DBD::Pg is a client-side application, so you need to install the
libpq-dev package (which is obviuosly missing, as the missing header
file indicates), not the package for server-side extensions.

Ralf
-- 
Wenn Du so minderbemittelt bist, daß Du es nötig hast, die Worte anderer
für Dich sprechen zu lassen, dann kann ich Dir meine Hilfe schlecht
versagen...
       – Thorsten Albers in <ntlqk6touens531uq58jk56oocp4hf7cb6@4ax.com>

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.postgresql

csiph-web