After install postgres, can't create extension plv8.
I'm use: CREATE EXTENSION plv8;
I'm getting:
ERROR: could not open extension control file "/usr/local/share/postgresql/extension/plv8.control": No such file or directory
********** Error **********
ERROR: could not open extension control file "/usr/local/share/postgresql/extension/plv8.control": No such file or directory
SQL state: 58P01
version postgres: 9.6.2 version pgAdmin4: 1.4
How to install plv8?
This should work on most platforms (https://github.com/plv8/plv8/issues/212#issuecomment-287589193):
$ easy_install pgxnclient
$ pgxnclient install plv8
It didn't work for me though. The only solution I came up with was building the library from source.
If you don't have wget installed, run:
$ brew install wget
Then run:
$ wget https://github.com/plv8/plv8/archive/v2.0.0.tar.gz
$ tar -xvzf v2.0.0.tar.gz
$ cd plv8-2.0.0
$ make static
$ make install
It worked for me.
I. Docker-images with postgres and plv8. It's free, images for Postgres 13 and 14 based on Debian and Alpine are available.
docker pull sibedge/postgres-plv8
Default is Alpine/last Postgres version. the complete tag list
Pay attention, that BigInt is not serializable in v8 and by default in plv8 v3.0.0 and higher BigInt numbers are converted into string(!). But if you need BigInt as numbers support, use this image with Postgres and specific version of plv8:
docker pull sibedge/postgres-plv8-bigint
II. Or, you can build images (for PostgreSQL with installed plv8) yourself with Dockerfiles:
Postgres 14.2, plv8 v3.0.0, Alpine based. size of image is 235MB.
Postgres 13.6, plv8 v3.0.0, Alpine based. size of image is 231MB.
Postgres 13.4, plv8 v2.13.15, Debian based. size of image is 351MB.
Postgres 13.6, plv8 v3.0.0, Debian based. size of image is 427MB.
III. Simple installing plv8 v3.0.0 on Debian Linux (PostgreSQL 13 must be preinstalled) :
$ git clone https://github.com/sibedge-llc/plv8-build.git
$ cd plv8-build
$ git checkout pg13-3.0.0-debian
$ sudo make install
I find a new way. Just copy and Paste! if you using postgresql version of: 9.5, 9.6 beta, 10 go this link to download package and learn what shoud you copy and where to past: https://github.com/JasperFx/marten/blob/master/documentation/documentation/admin/installing-plv8-windows.md
if you using postgresql version of: 9.3, 9.4, 9.5, 9.6, 10, 11 and 12 for downloading package you can go here: http://updates.xtuple.com/updates/plv8/win/xtuple_plv8.zip for downloading package and then copy past like has mentioned in first link