Thread: lpgport issue while installing pg_bulkload utility on fedora 14 OS

On 04/14/2014 06:21 AM, chiru r wrote:
> Hi,
>
> I am facing below *-lpgport *issue while installing pg_bulkload utility
> on fedora 14 OS.
>
> Details:
>
> *OS* : *Fedora 14*
>
> Linux localhost.localdomain 2.6.35.6-45.fc14.x86_64 #1 SMP Mon Oct 18
> 23:57:44 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux
>
> *PG* : PostgreSQL 8.4.9
>
> *pg_bulkload* 3.1.4
>
> [root@localhost pg_bulkload-3.1.4]# make
>
> make[1]: Entering directory `/home/postgres/pg_bulkload-3.1.4/bin'
>
> gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic
> -DLINUX_OOM_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
> -fwrapv pg_bulkload.o recovery.o pgut/pgut.o pgut/pgut-fe.o
> pgut/pgut-list.o -L/usr/lib64 -lpq -L/usr/lib64 -Wl,--as-needed -lpgport
> -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline
> -lcrypt -ldl -lm -o pg_bulkload
>
> */usr/bin/ld: cannot find -lpgport*
>
> collect2: ld returned 1 exit status
>
> make[1]: *** [pg_bulkload] Error 1
>
> make[1]: Leaving directory `/home/postgres/pg_bulkload-3.1.4/bin'
>
> make: *** [all] Error 2
>
> [root@localhost pg_bulkload-3.1.4]#
>
>
> Please share your experience on this issue.

Just what the docs say:

http://pgbulkload.projects.pgfoundry.org/pg_bulkload.html#install

$ cd pg_bulkload
$ make USE_PGXS=1
$ su
$ make USE_PGXS=1 install


>
> --Chiru
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/14/2014 07:21 AM, chiru r wrote:
>     Actually Just what the docs say:
>     http://pgbulkload.projects.__pgfoundry.org/pg_bulkload.__html#install
<http://pgbulkload.projects.pgfoundry.org/pg_bulkload.html#install>
>     $ cd pg_bulkload
>     $ make USE_PGXS=1
>     $ su
>     $ make USE_PGXS=1 install
>
>
> Thanks Adrian...
>
> USE_PGXS is already present in MAKEFILE.
> simple make and Make Install is working fine in Centos 5.9,i have
> successfully installed.
>
> But facing lpgport issue while installing on Fedora 14 OS.
>
> Even I have executed as per docs, also getting same *lpgport *issue.
>

Not sure how Fedora breaks out its packages, but do you have something
equivalent to postgresql-dev installed?

--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/14/2014 07:21 AM, chiru r wrote:
>     Actually Just what the docs say:
>     http://pgbulkload.projects.__pgfoundry.org/pg_bulkload.__html#install
<http://pgbulkload.projects.pgfoundry.org/pg_bulkload.html#install>
>     $ cd pg_bulkload
>     $ make USE_PGXS=1
>     $ su
>     $ make USE_PGXS=1 install
>
>
> Thanks Adrian...
>
> USE_PGXS is already present in MAKEFILE.
> simple make and Make Install is working fine in Centos 5.9,i have
> successfully installed.
>
> But facing lpgport issue while installing on Fedora 14 OS.
>
> Even I have executed as per docs, also getting same *lpgport *issue.
>

Realized that in my previous message I should have asked what is the
source of your Postgres packages? Some Googling shows this error
occurring quite often with Fedora, so this probably requires someone
with more experience with that distribution than I. In any case I have
to run, hope you find the answer.


--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/14/2014 07:56 AM, chiru r wrote:
> Okay,installed postgresql-devel.x86_64  package on fedora14 OS.
>
> Google blogs says it seems Fedora Postgresql-devel package not
> supported libpgport.
>
> _http://www.postgresql.org/message-id/4EE2338F.1040302@dunslane.net

The bigger issue is that the RedHat family discourages static libraries
in packages.

> _
>
> Is there any workaround.

Depends on your situation.

Is the server you are trying to build pg_bulkload a production server
that cannot be changed?

In other words is possible to build the server from source?

Failing that there is the part way there method. I am not sure how well
this would work, others may have comments on this.

1) Go here:
http://www.postgresql.org/ftp/source/

Find 8.4.9(FYI 8.4 is now up to release 8.4.21)

2) Do the make without the install in the source.

3) Find libpgport.a in ~/src/port/

4) Copy it to the Postgres library directory. Not sure where that is in
Fedora. Though a search for libpq.so should find it.

5) Cross fingers, retry build of pg_bulkloader.

>


--
Adrian Klaver
adrian.klaver@aklaver.com