PL/R install, no pgxs available
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
On 04/30/12 8:04 PM, Daniel Cole wrote:
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
<http://pgxs.mk>: No such file or directory/
/make: *** No rule to make target
`/usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk
<http://pgxs.mk>'. Stop./It is correct, I have no pgxs folder under lib, must less the src and
the makefiles.
if this was a Fedora/Redhat/CentOS YUM install of postgres,
yum install postgresql91-devel
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
On 04/30/12 8:22 PM, John R Pierce wrote:
On 04/30/12 8:04 PM, Daniel Cole wrote:
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
oops, on the RHEL6 yum install, thats
/usr/lib/postgresql/9.1/lib/pgxs
but as I said, that stuff is all in the -devel package, so maybe on your
system, its something similar.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
On 04/30/2012 06:31 PM, John R Pierce wrote:
On 04/30/12 8:04 PM, Daniel Cole wrote:
I am running/*USE_PGXS=1 make*/ in my PLR directory and it returns:
/Makefile:36: /usr/lib/postgresql/9.1/lib/pgxs
oops, on the RHEL6 yum install, thats
/usr/lib/postgresql/9.1/lib/pgxs
but as I said, that stuff is all in the -devel package, so maybe on your
system, its something similar.
Agreed -- he is missing the development package. It isn't clear to me
how he installed postgres in the first place nor which distribution
(maybe I missed it though...), but given this I would guess that the R
development package is missing as well (needed for R headers and libR.so
I believe...)
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
Thanks Joe and John,
You are right. I all needed was that dev package. On Ubuntu 4.4.3. I
ran: sudo apt-get install postgresql-server-dev-9.1
and then ran through the PLR install with no problem.
Thanks so much for the help.
Daniel
-----------------------------------------------------------
Daniel Cole
On Mon, Apr 30, 2012 at 11:05 PM, Joe Conway <mail@joeconway.com> wrote:
Show quoted text
On 04/30/2012 06:31 PM, John R Pierce wrote:
On 04/30/12 8:04 PM, Daniel Cole wrote:
I am running/*USE_PGXS=1 make*/ in my PLR directory and it returns:
/Makefile:36: /usr/lib/postgresql/9.1/lib/pgxs
oops, on the RHEL6 yum install, thats
/usr/lib/postgresql/9.1/lib/pgxs
but as I said, that stuff is all in the -devel package, so maybe on your
system, its something similar.Agreed -- he is missing the development package. It isn't clear to me
how he installed postgres in the first place nor which distribution
(maybe I missed it though...), but given this I would guess that the R
development package is missing as well (needed for R headers and libR.so
I believe...)Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general