Thread: PL/R install, no pgxs available
Hi Guys,
Thanks,
Daniel
-----------------------------------------------------------
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:
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:Agreed -- he is missing the development package. It isn't clear to me
>>>
>>> /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.
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