I am on MacOSX. I already have R and RStudio installed. I am running Postgres

Hey Dave! Thanks for the tip. The path is as follows: <div class

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Package libR was not found in the pkg-config search path about plr HOT 4 CLOSED

postgres-plr commented on September 14, 2024

Package libR was not found in the pkg-config search path

from plr.

Comments (4)

davecramer commented on September 14, 2024

You may have to set R_HOME

from plr.

mpatel-cai commented on September 14, 2024

Hey Dave! Thanks for the tip.

The path is as follows:

> R.home(component="home")
[1] "/Library/Frameworks/R.framework/Resources"

From the cloned plr repo, I run the following

mpatel@Meeras-MacBook-Pro plr % export R_HOME=/Library/Frameworks/R.framework/Resources**
mpatel@Meeras-MacBook-Pro plr % export PATH=$PATH:/usr/local/bin/postgres
mpatel@Meeras-MacBook-Pro plr % USE_PGXS=1 make
mpatel@Meeras-MacBook-Pro plr % USE_PGXS=1 make install
make: Nothing to be done for `all'.
/bin/sh /usr/local/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -d '/usr/local/lib/postgresql'
/bin/sh /usr/local/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -d '/usr/local/share/postgresql/extension'
/bin/sh /usr/local/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -d '/usr/local/share/postgresql/extension'
/usr/bin/install -c -m 755  plr.so '/usr/local/lib/postgresql/plr.so'
/usr/bin/install -c -m 644 .//plr.control '/usr/local/share/postgresql/extension/'
/usr/bin/install -c -m 644 .//plr--8.4.5.sql .//plr--unpackaged--8.4.5.sql .//plr--8.3.0.18--8.4.sql .//plr--8.4.1--8.4.2.sql .//plr--8.4.3--8.4.4.sql .//plr--8.4--8.4.1.sql .//plr--8.4.2--8.4.3.sql .//plr--8.4.4--8.4.5.sql  '/usr/local/share/postgresql/extension/'

When I try to setup the extension in Postgres, I am getting this message.

mpatel@Meeras-MacBook-Pro plr % psql athena
psql (14.1, server 13.5)
Type "help" for help.

athena=# CREATE EXTENSION plr;
ERROR:  extension "plr" has no installation script nor update path for version "8.4.5"

from plr.

davecramer commented on September 14, 2024

I just tried it on my MBP and it worked fine.

It appears that psql is version 14.1 and the server is 13.5. Is it possible it installed it in the wrong place ?

from plr.

mpatel-cai commented on September 14, 2024

@davecramer Thanks for looking into this. I had 2 installations of Postgres and the path was pointing to the wrong binary. It is working great now! This is a handy tool and am excited to have found it and get it running!

from plr.

Recommend Projects