Skip to content

Latest commit

 

History

History
150 lines (111 loc) · 4.38 KB

README.Windows.md

File metadata and controls

150 lines (111 loc) · 4.38 KB

Building GPDB client tools on Windows

We only support building 64-bit client tools on Windows using Visual Studio 2017. Building backend is not supported.

If not specified, all commands in this readme should be executed in x64 Native Tools Command Prompt.

Components of client tools

  • Command line client: psql, pg_dump, pg_dumpall
  • Script tools: createdb, createuser, dropdb, dropuser, clusterdb, vacuumdb
  • Loaders: gpfdist, gpload

Prerequisite

Tools

Install following tools and add them to PATH, make sure you can invoke them from cmd.

  1. Visual Studio build tools

Download and install "Visual C++ Build tools"

  1. CMake

Download and install latest Windows win64-x64 Installer.

  1. Git

Download and install.

  1. Flex and Bison via MSYS2

Download and install latest x86_64 package.

After installation, open MSYS2 command line, run pacman -S flex bison. Add <msys2>\usr\bin to PATH.

  1. Perl

Download 64-bit and install.

  1. Python 3

Download Windows x86-64 MSI installer and install.

Required dependencies of gpfdist

We will install all dependencies to C:\dep. If you want another location, make sure you've changed C:\dep in the following scripts.

  1. zlib
git clone --branch v1.2.11 --depth 1 https://github.com/madler/zlib.git
cd zlib

mkdir build
cd build
cmake -DCMAKE_INSTALL_PREFIX:PATH=C:\dep -G "Visual Studio 15 2017 Win64" ..
cmake --build . --config Release --target ALL_BUILD
cmake --build . --config Release --target INSTALL
copy C:\dep\lib\zlibstatic.lib C:\dep\lib\zdll.lib
  1. libapr
git clone --branch 1.6.5 --depth 1 https://github.com/apache/apr.git
cd apr
mkdir build2
cd build2
cmake -DCMAKE_INSTALL_PREFIX:PATH=C:\dep -G "Visual Studio 15 2017 Win64" ..
cmake --build . --config Release --target ALL_BUILD
cmake --build . --config Release --target INSTALL
  1. libevent
git clone --branch release-2.1.8-stable --depth 1 https://github.com/libevent/libevent.git
cd libevent
mkdir build
cd build
cmake -DEVENT__DISABLE_OPENSSL=ON -DCMAKE_INSTALL_PREFIX:PATH=C:\dep -G "Visual Studio 15 2017 Win64" ..
cmake --build . --config Release --target ALL_BUILD
cmake --build . --config Release --target INSTALL

Optional dependencies

We will install all dependencies to C:\dep. If you want another location, make sure you've changed C:\dep in the following scripts.

  1. OpenSSL 1.0.2
git clone --branch OpenSSL_1_0_2r --depth 1 https://github.com/openssl/openssl
cd openssl
perl Configure --prefix=C:\dep VC-WIN64A 
ms\do_win64a
nmake -f ms\ntdll.mak
nmake -f ms\ntdll.mak install
  1. Kerberos
git clone --branch krb5-1.17-final --depth 1 https://github.com/krb5/krb5.git
cd krb5
set NO_LEASH=1
set PATH=%PATH%;"%WindowsSdkVerBinPath%"\x86
set KRB_INSTALL_DIR=C:\dep
cd src
nmake -f Makefile.in prep-windows
nmake NODEBUG=1
nmake install NODEBUG=1

Build steps

Replace <path\to\gpdb> with real location of your gpdb source code. Make sure you have also cloned the submodule at gpMgmt\bin\pythonSrc\ext.

We will install client package to C:\greenplum-db-devel. If you want another location, make sure you've replaced C:\greenplum-db-devel in the following scripts.

  1. Create config.pl at src/tools/msvc. If you don't build with these supports, it's ok to skip this step.
cd <path\to\gpdb>\src\tools\msvc
echo print "our \$config = {gss => 'c:/dep', openssl => 'c:/dep', zlib => 'c:/dep'};" | perl >config.pl
  1. Build postgres clients and scripts
cd <path\to\gpdb>\src\tools\msvc
build client
install C:\greenplum-db-devel client
  1. Build gpfdist
cd <path\to\gpdb>\src\bin\gpfdist
cd build
cmake -DCMAKE_PREFIX_PATH:PATH=C:\ext -DCMAKE_INSTALL_PREFIX:PATH=C:\greenplum-db-devel -G "Visual Studio 15 2017 Win64" ..
cmake --build . --config Release --target ALL_BUILD
cmake --build . --config Release --target INSTALL
  1. Build psycopg2, needed by gpload
1. Ensure that a 64-bit version of Python 3 is installed on your system. Refer to [Python Releases for Windows](https://www.python.org/downloads/windows/) or the source of your choice for Python download and install instructions.
2. Add the Python directory to your `PATH`.
3. Use `pip` to install the following `gpload` dependencies: pip install psycopg2 pyyaml