DEV Community

Junichi Kajiwara
Junichi Kajiwara

Posted on • Updated on

How to build plv8 on Windows

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

TL;DR;

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
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

when building is success,you'll get this.

plv8-2.1.0-postgresql-9.6-x64.zip
Enter fullscreen mode Exit fullscreen mode

Unzip it, and copy to PostgreSQL directories.

Top comments (0)