Install javascript pl/v8 extension on PostgreSQL on Ubuntu

Installation on Debian 9 + PostgreSQL 10 (5/2018):

• sudo apt-get install libv8-dev postgresql-10-plv8
• in psql: create extension plv8

Installation on Ubuntu 14.04 (standard installation with “apt-get dist-upgrade”).

There are several ways how to do it:

1. using standard package (in 02/2016 not available for pg 9.5):
   • sudo apt-get install libv8
   • sudo apt-get install postgresql-9.x-plv8
2. using pgxn client (works also on pg 9.5):
   • in terminal:
     • sudo pip install pgxnclient
       • if pip is not available, install it:
         • sudo apt-get -y install python-pip
     • sudo apt-get install libv8-dev
     • sudo pgxn install plv8
   • in PostgreSQL (pgadmin3 or psql):
     • create extension plv8;

On Ubuntu 15.10 somehow none of this worked. Therefore I had to use install instructions from github file plv8-install-ubuntu.md

You may also need to generate UUID, PostgreSQL has an extension for it:

• CREATE EXTENSION “uuid-ossp”;