Обсуждение: lpgport issue while installing pg_bulkload utility on fedora 14 OS
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.
--Chiru
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
Actually 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
On 04/14/2014 06:21 AM, chiru r wrote:Hi,
I am facing below *-lpgport *issue while installing pg_bulkload utility*OS* : *Fedora 14*
on fedora 14 OS.
Details:*PG* : PostgreSQL 8.4.9
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_bulkload* 3.1.4*/usr/bin/ld: cannot find -lpgport*
[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
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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: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>Even I have executed as per docs, also getting same *lpgport *issue.
$ 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.
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