Re: Error in DBD-Pg-3.10.0

David Christensen <[email protected]> Mon, 25 May 2020 16:44:55 -0500
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
--Apple-Mail-59492B5C-6D86-49BC-89C7-1EC2C4D92B98
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Have you installed =E2=80=9Clibpq-dev=E2=80=9D or equivalent package?

Sent from my iPhone

> On May 25, 2020, at 5:41 AM, Ankush Chawla <[email protected]> wrot=
e:
>=20
> =EF=BB=BF
> OS : Red Hat Linux 8
> [root@ip-172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_HOME=3D/usr/pgsql-1=
1
> [root@ip-172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_LIB=3D/usr/pgsql-11=
/lib
> [root@ip-172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_INCLUDE=3D/usr/incl=
ude
> [root@ip-172-31-37-207 DBD-Pg-3.10.0]# perl Makefile.PL
> Configuring DBD::Pg 3.10.0
> PostgreSQL version: 110008 (default port: 5432)
> POSTGRES_HOME: /usr/pgsql-11
> POSTGRES_INCLUDE: /usr/include
> POSTGRES_LIB: /usr/pgsql-11/lib
> OS: linux
> Warning: prerequisite Test::More 0.88 not found.
> Using DBI 1.641 (for perl 5.026003 on x86_64-linux-thread-multi) installed=
 in /usr/local/lib64/perl5/auto/DBI/
> Generating a Unix-style Makefile
> Writing Makefile for DBD::Pg
> Writing MYMETA.yml and MYMETA.json
> [root@ip-172-31-37-207 DBD-Pg-3.10.0]# make
> Skip blib/lib/DBD/Pg.pm (unchanged)
> Skip blib/lib/Bundle/DBD/Pg.pm (unchanged)
> Running Mkbootstrap for Pg ()
> chmod 644 "Pg.bs"
> "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Pg.bs blib/arc=
h/auto/DBD/Pg/Pg.bs 644
> gcc -c  -I/usr/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_G=
NU_SOURCE -O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=
=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecor=
d-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=3D/us=
r/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-unw=
ind-tables -fstack-clash-protection -fcf-protection -fwrapv -fno-strict-alia=
sing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 -DPGL=
IBVERSION=3D110008 -DPGDEFPORT=3D5432 -g  -DPERL_EXTMALLOC_DEF -Dmalloc=3DPe=
rl_malloc -Dfree=3DPerl_mfree -Drealloc=3DPerl_realloc -Dcalloc=3DPerl_callo=
c -DVERSION=3D\"3.10.0\" -DXS_VERSION=3D\"3.10.0\" -fPIC "-I/usr/lib64/perl5=
/CORE"   Pg.c
> In file included from Pg.xs:14:
> Pg.h:33:10: fatal error: libpq-fe.h: No such file or directory
>  #include "libpq-fe.h"
>           ^~~~~~~~~~~~
> compilation terminated.
>=20
> Please suggest
> --=20
> Best Regards,
> Ankush Chawla
>=20

--Apple-Mail-59492B5C-6D86-49BC-89C7-1EC2C4D92B98
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Have you installed =E2=80=9Clibpq-dev=E2=80=
=9D or equivalent package?<br><br><div dir=3D"ltr">Sent from my iPhone</div>=
<div dir=3D"ltr"><br><blockquote type=3D"cite">On May 25, 2020, at 5:41 AM, A=
nkush Chawla &lt;[email protected]&gt; wrote:<br><br></blockquote></d=
iv><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr"><div=
><b><font color=3D"#0000ff">OS : Red Hat Linux 8</font></b></div><div><font c=
olor=3D"#0000ff"><b>[root@ip-172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_H=
OME=3D/usr/pgsql-11<br></b></font></div><font color=3D"#0000ff"><b>[root@ip-=
172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_LIB=3D/usr/pgsql-11/lib<br>[ro=
ot@ip-172-31-37-207 DBD-Pg-3.10.0]# export POSTGRES_INCLUDE=3D/usr/include<b=
r>[root@ip-172-31-37-207 DBD-Pg-3.10.0]# perl Makefile.PL</b></font><br>Conf=
iguring DBD::Pg 3.10.0<br>PostgreSQL version: 110008 (default port: 5432)<br=
>POSTGRES_HOME: /usr/pgsql-11<br>POSTGRES_INCLUDE: /usr/include<br>POSTGRES_=
LIB: /usr/pgsql-11/lib<br>OS: linux<br>Warning: prerequisite Test::More 0.88=
 not found.<br>Using DBI 1.641 (for perl 5.026003 on x86_64-linux-thread-mul=
ti) installed in /usr/local/lib64/perl5/auto/DBI/<br>Generating a Unix-style=
 Makefile<br>Writing Makefile for DBD::Pg<br>Writing MYMETA.yml and MYMETA.j=
son<br><b><font color=3D"#0000ff">[root@ip-172-31-37-207 DBD-Pg-3.10.0]# mak=
e</font></b><br>Skip blib/lib/DBD/Pg.pm (unchanged)<br>Skip blib/lib/Bundle/=
DBD/Pg.pm (unchanged)<br>Running Mkbootstrap for Pg ()<br>chmod 644 "Pg.bs"<=
br>"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Pg.bs blib/ar=
ch/auto/DBD/Pg/Pg.bs 644<br>gcc -c &nbsp;-I/usr/include -I/usr/local/lib64/p=
erl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -O2 -g -pipe -Wall -Werror=3Dformat=
-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -=
fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/r=
edhat-hardened-cc1 -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtu=
ne=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-prot=
ection -fwrapv -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE=
 -D_FILE_OFFSET_BITS=3D64 -DPGLIBVERSION=3D110008 -DPGDEFPORT=3D5432 -g &nbs=
p;-DPERL_EXTMALLOC_DEF -Dmalloc=3DPerl_malloc -Dfree=3DPerl_mfree -Drealloc=3D=
Perl_realloc -Dcalloc=3DPerl_calloc -DVERSION=3D\"3.10.0\" -DXS_VERSION=3D\"=
3.10.0\" -fPIC "-I/usr/lib64/perl5/CORE" &nbsp; Pg.c<br>In file included fro=
m Pg.xs:14:<br>Pg.h:33:10: fatal error: libpq-fe.h: No such file or director=
y<br>&nbsp;#include "libpq-fe.h"<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ^~~~~=
~~~~~~~<br>compilation terminated.<br clear=3D"all"><div><font color=3D"#000=
0ff"><br></font></div><div><font color=3D"#0000ff"><b>Please suggest</b></fo=
nt></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D=
"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"lt=
r">Best Regards,<br>Ankush Chawla<br><br></div></div></div></div></div></div=
></div>
</div></blockquote></body></html>=

--Apple-Mail-59492B5C-6D86-49BC-89C7-1EC2C4D92B98--