search

jconway / plr

PL/R - R Procedural Language for PostgreSQL
http://www.joeconway.com
90 stars 41 forks source link

Does PL/R work with PostgreSQL 9.4? #9

Closed iangow closed 10 years ago

iangow commented 10 years ago

Joe:

Does PL/R work with PostgreSQL 9.4?

I looked into upgrading my server to 9.4 to get access to some JSON functions that are precisely what I was looking for today, but pg_upgrade won't let me do it without PL/R (I'd want that anyway). I complile PL/R fine, but when I go to upgrade I get the following error message:

Could not load library "$libdir/plr"
ERROR:  could not load library "/opt/local/lib/postgresql94/plr.so": dlopen(/opt/local/lib/postgresql94/plr.so, 10): Symbol not found: _MemoryContextSwitchTo
  Referenced from: /opt/local/lib/postgresql94/plr.so
  Expected in: /opt/local/lib/postgresql94/bin/postgres
 in /opt/local/lib/postgresql94/plr.so

Thanks.

-Ian

jconway commented 10 years ago

Haven't tried recently. Will look at it next week. Joe

On July 11, 2014 1:08:10 AM GMT+01:00, Ian Gow notifications@github.com wrote:

Joe:

Does PL/R work with PostgreSQL 9.4?

I looked into upgrading my server to 9.4 to get access to some JSON functions that are precisely what I was looking for today, but pg_upgrade won't let me do it without PL/R (I'd want that anyway). I complile PL/R fine, but when I go to upgrade I get the following error message:

Could not load library "$libdir/plr"
ERROR:  could not load library "/opt/local/lib/postgresql94/plr.so":
dlopen(/opt/local/lib/postgresql94/plr.so, 10): Symbol not found:
_MemoryContextSwitchTo
 Referenced from: /opt/local/lib/postgresql94/plr.so
 Expected in: /opt/local/lib/postgresql94/bin/postgres
in /opt/local/lib/postgresql94/plr.so

Thanks.

-Ian

Reply to this email directly or view it on GitHub: https://github.com/jconway/plr/issues/9

Sent from my Android device with K-9 Mail. Please excuse my brevity.

iangow commented 10 years ago

I got it to work. It seems that PostgreSQL 9.3 was somehow interfering (even though I was using USE_PGXS=1 and the PG_CONFIG flag pointed to the 9.4 binary). Shutting down the 9.3 server seemed to solve this on my laptop.

(Alas pg_upgrade became irrelevant, as I got too happy with sudo rm -rf and deleted my 9.3 data directory; now restoring from my other desktop.)