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

Groups > comp.databases.postgresql > #569

Re: install perl DBD::Pg problem

Show all headers | View raw

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.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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

csiph-web