Collapse AllExpand All

8. Windows Servers

Perform the following steps on your Windows server:

  • Download our Windows plv8 bundle

  • Extract this archive to the server Desktop

  • Find the folder where PostgreSQL is installed. This should have sub-folders named bin, lib, shared, etc. Write down the full directory path, which looks something like C:\Program Files\PostgreSQL\9.3 for 64bit or C:\Program Files (x86)\PostgreSQL\9.3 for 32bit.

  • Open an Administrator command prompt on your Windows Server.

    • Typically, Start > All Programs > Accessories > Right click on command prompt and Run as Administrator

    • Alternatively, search for "Command Prompt", when it appears in the search results right click and Run as Administrator

  • Type the following (> is the shell prompt - don't type that part):

    > cd %HOMEPATH%\Desktop\xtuple_plv8
    > cd %HOMEPATH%\Desktop\xtuple_plv8
    > install_plv8.bat
  • Choose what version of PostgreSQL that you are running

  • Enter the full path to the PostgreSQL installation directory when install_plv8.bat asks. If you make a mistake, it'll just ask again. Type CTRL-C to quit if you can't remember the full path.

  • install_plv8.bat will run for another second or two and you'll get a shell prompt back.

Now create the extension as described above.