PL/R install, no pgxs available

Started by Daniel Coleabout 14 years ago5 messagesgeneral
Jump to latest
#1Daniel Cole
daniel@southernsolutionsms.com

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

#2John R Pierce
pierce@hogranch.com
In reply to: Daniel Cole (#1)
Re: PL/R install, no pgxs available

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&gt;: 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&gt;&#39;. 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

#3John R Pierce
pierce@hogranch.com
In reply to: John R Pierce (#2)
Re: PL/R install, no pgxs available

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

#4Joe Conway
mail@joeconway.com
In reply to: John R Pierce (#3)
Re: PL/R install, no pgxs available

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

#5Daniel Cole
daniel@southernsolutionsms.com
In reply to: Joe Conway (#4)
Re: PL/R install, no pgxs available

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