How to build plv8 on Windows

This article is obsolete.Now officially plv8 supports for Windows!

TL;DR;

• https://github.com/plv8/plv8/pull/239

Let's try

You need following:

• vs2015/vs2017
• Postgres9.6
• git(and patch.exe)
• cmake
• nuget.exe

$ git clone https://github.com/kjunichi/plv8.git
$ cd plv8
$ git checkout support-msvc

you have to patch to PostgreSQL's header file.

copy "c:\Program Files\PostgreSQL\9.6\include\server\port\atomics\generic-msvc.h" .
set path=%path%;c:\Program Files\Git\usr\bin
patch --binary -p1 generic-msvc.h < generic-msvc.h

then,you copy patched generic-msvc.h to PostgreSQL's header file(c:\Program Files\PostgreSQL\9.6\include\server\port\atomics\generic-msvc.h).

$ bootstrap.bat
$ cmake . -G "Visual Studio 14 2015 Win64" -DCMAKE_INSTALL_PREFIX="C:\Program Files\PostgreSQL\9.6" -DPOSTGRESQL_VERSION=9.6
$ cmake --build . --config Release --target Package

when building is success,you'll get this.

plv8-2.1.0-postgresql-9.6-x64.zip

Unzip it, and copy to PostgreSQL directories.