PL/R install, no pgxs available

From: Daniel Cole <daniel(at)southernsolutionsms(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PL/R install, no pgxs available
Date: 2012-05-01 03:04:06
Message-ID: CAE6KOUjR+-PM1mc-4u4RWyro9=s0sA-SzB+JFmSrAgx=zS94Lw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Guys,

Have 9.1.3 running with Postgis 2.0 . Trying to add PR/R and getting some
errors about my postgres install. I found some similar messages, but none
with a workable solution for me. Any thoughts are very appreciated.

I am running* USE_PGXS=1 make* in my PLR directory and it returns:

*Makefile:36: /usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk: No
such file or directory*
*make: *** No rule to make target
`/usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk'. Stop.*

It is correct, I have no pgxs folder under lib, must less the src and the
makefiles. I have read 35.16 in the 9.1 documentation on building the
makefile for pgxs, but I really don't understand it and not sure it even
relates to what I am doing. (
http://www.postgresql.org/docs/9.1/static/extend-pgxs.html) I can't
understand if I am suppose to create those directories and build up the
makefiles myself (I sure hope not), or install some sort of pg dev kit or
what.

*Here is my pg_config:*
BINDIR = /usr/lib/postgresql/9.1/bin
DOCDIR = /usr/share/doc/postgresql-doc-9.1
HTMLDIR = /usr/share/doc/postgresql-doc-9.1
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/9.1/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/9.1/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/9.1/man
SHAREDIR = /usr/share/postgresql/9.1
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-tcl' '--with-perl' '--with-python' '--with-pam'
'--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml'
'--with-libxslt' '--with-ldap' '--with-tclconfig=/usr/lib/tcl8.5'
'--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5'
'PYTHON=/usr/bin/python' '--mandir=/usr/share/postgresql/9.1/man'
'--docdir=/usr/share/doc/postgresql-doc-9.1'
'--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/'
'--datadir=/usr/share/postgresql/9.1'
'--bindir=/usr/lib/postgresql/9.1/bin' '--libdir=/usr/lib/'
'--libexecdir=/usr/lib/postgresql/' '--includedir=/usr/include/postgresql/'
'--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety'
'--enable-debug' '--disable-rpath' '--with-ossp-uuid' '--with-gnu-ld'
'--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-g
-O2 -fPIC -DLINUX_OOM_ADJ=0 -fPIC -DLINUX_OOM_ADJ=0'
'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed'
'CPPFLAGS='
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5
CFLAGS = -g -O2 -fPIC -DLINUX_OOM_ADJ=0 -fPIC -DLINUX_OOM_ADJ=0 -Wall
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed
-Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err
-lgssapi_krb5 -lz -ledit -lcrypt -ldl -lm
VERSION = PostgreSQL 9.1.3

Please tell me any ideas you have. I am at a stand still on this.

Thanks,

Daniel

-----------------------------------------------------------
Daniel Cole

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-05-01 03:22:39 Re: PL/R install, no pgxs available
Previous Message leaf_yxj 2012-05-01 00:55:22 Re: Test ODBC connection failed. Pleae help me to take a look. Thanks.