Skip to content

Instantly share code, notes, and snippets.

@benjie
Created April 1, 2016 09:15
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benjie/3f80aaf22eda84726a5daa228e19d682 to your computer and use it in GitHub Desktop.
Save benjie/3f80aaf22eda84726a5daa228e19d682 to your computer and use it in GitHub Desktop.
Easy plv8 on OSX

Heroku runs plv8 v1.4.2 (checked on 1st April 2016). On OSX it's easiest to install v1.4.3 since that allows V8 3.15 which is available via homebrew. (1.4.2 wants V8 3.14.5).

To install:

brew install v8-315
pip install pgxnclient
LIBRARY_PATH="/usr/local/opt/v8-315/lib" CPATH="/usr/local/opt/v8-315/include" pgxnclient install plv8=1.4.3

To test it worked:

$ psql
# CREATE EXTENSION plv8;
CREATE EXTENSION
# DO $$ plv8.elog(NOTICE, "Hello World") $$ LANGUAGE plv8;
NOTICE:  Hello World
DO
# DROP EXTENSION plv8;
DROP EXTENSION
# 
@jtiemann
Copy link

worked like a charm, many thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment