Skip to content

Instantly share code, notes, and snippets.

@benjie
Created April 1, 2016 09:15
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save benjie/5120a175267dfb96adcf1ee2929033a6 to your computer and use it in GitHub Desktop.
Save benjie/5120a175267dfb96adcf1ee2929033a6 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
# 
@benjie
Copy link
Author

benjie commented Jan 18, 2023

🤷‍♂️ I don’t use plv8 any more

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